Snap Id Snap Time Sessions Cursors/Session
Begin Snap: 1663 21-Jul-08 10:00:28 80 10.9
End Snap: 1686 21-Jul-08 16:08:01 172 11.5
Elapsed: 367.55 (mins)
DB Time: 4,879.90 (mins)
I am looking at the "DB Time" of 4879.90 minutes; and comparing the value with my elapsed time - not sure if its ok to see a higher DB time than elapsed time.
07-22-2008, 02:44 AM
Elapsed time is the duration of your snapshot. DB time means CPU time consumed during that elapsed time. So you should have definitely more then 4879.90/367.55 >= 14 cpu. Now check your cpu utilization , let's say if it's 50%, that means you got 14*(100/50)=28 cpu.
07-22-2008, 11:10 PM
I am not so sure that snapshot differentiate between different cpu's . I never have seen db time higher than elapsed time. Could it be a bug ?
07-24-2008, 01:57 AM
No i do not think it's a bug, if you got a very busy system(cou intensive operations)with multpile cpus, you can see it.