RE: cpu waits

  • From: "Luca Canali" <Luca.Canali@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 28 Feb 2007 11:04:17 +0100

There is no such event, indeed it is a typical pitfall say when
analysing a statspack report on a CPU bound DB server.
The exception being when resource manager is used, then one can look at
the time spent in 'resmgr:cpu quantum'  wait event.
 
Cheers,
L.

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of amonte
Sent: Wednesday, February 28, 2007 9:23 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: cpu waits


Hi all

I was wondering what event does Oracle show when the process cannot get
CPU cycles?

TIA

Alex


Other related posts: