RE: PLSQL CPU consumption

From: Adrian <ade.turner_at_gmail.com>
Date: Mon, 25 Sep 2006 20:38:26 +0100
Message-ID: <45183034.12c556da.2f6b.ffffecf9@mx.gmail.com>

Hi David,

Sorry, I'm not onsite (UK based) so cant give you exact info, but pretty much

Latch Free(librarycache) 50%

CPU Time,                                45%

sequential read(much lower)       5%

The latch frees only appear under CPU starvation. Under normal load its 90% to CPU Time.

Tkprof output does not seem to show the considerable cpu time attributed by v$sqlarea to the package call.

Cheers

Adrian

From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: 25 September 2006 20:33
To: ade.turner_at_gmail.com
Cc: oracle-l_at_freelists.org
Subject: Re: PLSQL CPU consumption

what are you biggest wait / timed events

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Sep 25 2006 - 14:38:26 CDT