switching perl version

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 big.
Do you think this perl new version (5.8.5) takes more cpu ?
I appreciate any idea you could give me to improve my performance.

--
Open WebMail Project (http://openwebmail.org)

RE: switching perl version

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:ogomez@epq.com.co]=20
Sent: Friday, September 08, 2006 9:04 AM
To: dbi-users@perl.org
Subject: switching perl version

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 big.
Do you think this perl new version (5.8.5) takes more cpu ?
I appreciate any idea you could give me to improve my performance.

--
Open WebMail Project (http://openwebmail.org)


This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RE: switching perl version

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:ogomez@epq.com.co]=20
Sent: Friday, September 08, 2006 10:04 AM
To: dbi-users@perl.org
Subject: switching perl version


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 big.
Do you think this perl new version (5.8.5) takes more cpu ?
I appreciate any idea you could give me to improve my performance.

--
Open WebMail Project (http://openwebmail.org)

Re: switching perl version

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:ogomez@epq.com.co]
> Sent: Friday, September 08, 2006 9:04 AM
> To: dbi-users@perl.org
> Subject: switching perl version
>
> 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 big.
> Do you think this perl new version (5.8.5) takes more cpu ?
> I appreciate any idea you could give me to improve my performance.

You've changed every aspect of your system. I think Ron's good
suggestions are a minimum in terms of researching why the
performance is slower. Perl is about the last place I'd look.

As for the cpu numbers, higher % cpu should tranlsate to faster
performance, everything else equal, which it's not in this case.
In particular, I'm told by our sys admin that the Linux 2.4 kernel
(i.e. RH 7.0) reports CPU differently than the 2.6 kernel (i.e. ES 4).
And I/O scheduling has changed.
But this is pretty far off topic for the DBI list.

-Chris

RE: switching perl version

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 said Perl is the last place you should look, and I agree.
Your issues are almost assuredly database centric. You should eliminate
this as a candidate before you do anything else and the best way to do
this is process profiling using 10046 trace files to determine the
issues.

Cary Milsap has a really exceptional book on this subject -
http://www.oreilly.com/catalog/optoraclep/. You should get a copy and
read it several times because it is a bigger subject than most can
imagine.

You should also be looking on metalink for answers on how to trace
sessions, although the links I sent you the other day should work fine
for starters.

Performance issues are a large vague subject and until you can pinpoint
the issues, you are like a cat chasing its tail - lots of effort, little
reward or progress.

rr

-----Original Message-----
From: Oscar Gomez [mailto:ogomez@epq.com.co]=20
Sent: Friday, September 08, 2006 9:28 AM
To: Reidy, Ron
Subject: RE: switching perl version

Hi Ron, thanks for your reply
I haven't tried the 10046 trace, because I still am studying how to do
it.
but what is the relationship or the reliance between the cpu performance
and
oracle under the new versions install.

thanks a lot=20
--
Open WebMail Project (http://openwebmail.org)


---------- Original Message -----------
From: "Reidy, Ron"
To: "Oscar Gomez" ,
Sent: Fri, 8 Sep 2006 09:26:47 -0600
Subject: RE: switching perl version

> Did you run 10046 traces on the code?
>=20
> Have you profiled the code?
>=20
> I switched to these same versions a couple of years ago, and have=20
> had no problems.
>=20
> rr
>=20
> -----Original Message-----
> From: Oscar Gomez [mailto:ogomez@epq.com.co]=20
> Sent: Friday, September 08, 2006 9:04 AM
> To: dbi-users@perl.org
> Subject: switching perl version
>=20
> 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=20
> program in linux enterprise ES 4, perl v. 5.8.5, Oracle 10g. uses=20
> 60% cpu. I'd like to know what's happening because the performance=20
> is slower and the difference is wide big. Do you think this perl new=20
> version (5.8.5) takes more cpu ? I appreciate any idea you could=20
> give me to improve my performance.
>=20
> --
> Open WebMail Project (http://openwebmail.org)
>=20
> This electronic message transmission is a PRIVATE communication=20
> which contains information which may be confidential or privileged.=20
> The information is intended to be for the use of the individual or=20
> entity named above. If you are not the intended recipient, please be=20
> aware that any disclosure, copying, distribution or use of the=20
> contents of this information is prohibited. Please notify the sender=20
> of the delivery error by replying to this message, or notify us by=20
> telephone (877-633-2436, ext. 0), and then delete it from your system.
------- End of Original Message -------

RE: switching perl version

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.

-- Jeff Horn

-----Original Message-----
From: Oscar Gomez [mailto:ogomez@epq.com.co]
Sent: Friday, September 08, 2006 10:04 AM
To: dbi-users@perl.org
Subject: switching perl version

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 big.
Do you think this perl new version (5.8.5) takes more cpu ?
I appreciate any idea you could give me to improve my performance.

--
Open WebMail Project (http://openwebmail.org)