RE: PLSQL CPU consumption

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@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: