A perl program executing in linux Redhat 7.0, perl version 5.6, oracle 8i was
using 30% cpu approx. Now I'm running the same program in linux enterprise ES 4,
perl v. 5.8.5, Oracle 10g. uses 60% cpu. I'd like to know what's happening
because the performance is slower and the difference is wide
Did you run 10046 traces on the code?
Have you profiled the code?
I switched to these same versions a couple of years ago, and have had no
problems.
rr
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 9:04 AM
To: dbi-users@perl.org
On Sep 8, 2006, at 11:26 AM, Reidy, Ron wrote:
Did you run 10046 traces on the code?
Have you profiled the code?
I switched to these same versions a couple of years ago, and have
had no
problems.
rr
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday,
The differences are big. I won't go into them here because these are
off topic, but if your DB was an 8.1 and migrated in place to 10g, you
will have performance problems, especially if there were no changes made
to init parameters, you changes hardware platforms (word size), etc.
Another poster
Addison, Mark wrote:
Mark,
Stumbled upon your email from June, and am very sorry to not have seen
it and responded. I will have a fix for this within days with the
release of DBD::mysql 3.0007/3.0007_1
Kind regards,
Patrick
Hello,
I upgraded DBD::mysql from 2.9006-1 to 3.0006-1 and
On Fri, 2006-09-08 at 11:56 -0400, Patrick Galbraith wrote:
Addison, Mark wrote:
Mark,
Stumbled upon your email from June, and am very sorry to not have seen
it and responded. I will have a fix for this within days with the
release of DBD::mysql 3.0007/3.0007_1
Excellent, my logs will
I would definitely look to Oracle rather than Perl as your
culprit. I don't have anything to back this up, just a suspicion.
-Original Message-
From: Oscar Gomez [mailto:[EMAIL PROTECTED]
Sent: Friday, September 08, 2006 10:04 AM
To: dbi-users@perl.org
Subject: switching perl
What (if any) hardware changes have happened? If you've moved to a machine
with lots more RAM a memory intensive program that was paging and swapping
could all of a sudden keep more data in memory and become more CPU
intensive. That memory could be consumed by either Perl or Oracle or both.
--