RE: Missing time in 10046 trace file

Paul, 

>tim value of the FETCH 2276365740 from the time value of the EXEC
>2276356674 I get approx 90 seconds (9066 centi-secs) which is nowhere
>close to adding all the ela's of the waits (48 centi-secs).  Am I
>looking at what they call unmeasured/unaccounted-for time?

Note that latches can 'sleep' and while they are sleeping, this time isn't
counted under 'waiting'. This sleep is successivley for longer periods... I
think Steve Adams discussed this very clearly in his book. If you look at
Statspack snapshots between these periods, you might see more than usual
values under the SLEEP[n] columns. And yes, when CPU thrashing occurs, the
unaccounted time increases as the context switching times are not counted
within Oracle....

Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

Listen to great, commercial-free christian music 24x7x365 at
http://www.klove.com

** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
--
http://www.freelists.org/webpage/oracle-l

Other related posts: