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