[10.2.0.4 on W2K3] DB Time = 3 X Elapsed time in AWR report
Hi,
I've got something strange on an AWR report : DB Time is 3 times greater than Elapsed time, Though I only have 1 core on my machine (which is a VMware virtual machine located on a physical machine 2 sockets, 8 cores).
Do you have any explanations ?
Rgds,
Frederic
Do you have any explanations ?
Rgds,
Frederic
|
|
|
|
|
|
| |
|
| Snap Id | Snap Time | Sessions | Cursors/Session |
|---|---|---|---|---|
| Begin Snap: | 13305 | 15-Déc. -10 16:00:23 | 78 | 118.1 |
| End Snap: | 13306 | 15-Déc. -10 17:00:31 | 79 | 110.4 |
| Elapsed: | 60.13 (mins) | |||
| DB Time: | 155.27 (mins) |
Report Summary
Top 5 Timed Events
| Event | Waits | Time(s) | Avg Wait(ms) | % Total Call Time | Wait Class |
|---|---|---|---|---|---|
| enq: TX - row lock contention | 2,997 | 8,983 | 2,997 | 96.4 | Application |
| CPU time | 150 | 1.6 | |||
| db file sequential read | 4,800 | 116 | 24 | 1.2 | User I/O |
0