RE: PLSQL CPU consumption

  • From: Adrian <ade.turner@xxxxxxxxx>
  • To: "'David Sharples'" <davidsharples@xxxxxxxxx>, <ade.turner@xxxxxxxxx>
  • Date: Mon, 25 Sep 2006 20:38:26 +0100

Hi David,


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


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.






From: David Sharples [mailto:davidsharples@xxxxxxxxx] 
Sent: 25 September 2006 20:33
To: ade.turner@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: PLSQL CPU consumption


what are you biggest wait  / timed events

Other related posts: