CPU_time much higher than elapsed_time
December 5, 2012 1 Comment
Of course, one of the first places you should go is Oracle Support, but if you, like me, put off doing that and scratch your head for a while wondering why ELAPSED_TIME in V$SQL might be significantly lower than CPU_TIME when there are no obvious other explanations, then note these two bugs in 11.1.0.7:
BUG 7168259 – Millisecond elapsed_time shows as 0 : Elapsed_time for SQL statements which execute in under one millisecond can show up as 0
BUG 7561762 – Elapsed_time is under-reported : Elapsed_time can be 0 or significantly less than V$SQL.CPU_TIME if there is significant idle wait class time
Advertisements
Hi,
could it also be when an SQL run in Parallel mode that the summary of CPU time consumed is much higher then elapsed ? Means is Elapsed the time for start of the SQL execution/parsing till the SQL retrived all rows or just a summary of all Timings (CPU+WAIT+I/O)?
cheers and merry christmas
/Karl