Top 10 Foreground Events by Total Wait Time
Event | Waits | Total Wait Time (sec) | Wait Avg(ms) | % DB time | Wait Class |
---|---|---|---|---|---|
enq: HW - contention | 541 | 77.5K | 143220 | 53.4 | Configuration |
log file sync | 82,765 | 44.8K | 541 | 30.9 | Commit |
buffer busy waits | 1,496 | 19K | 12689 | 13.1 | Concurrency |
enq: SV - contention | 284 | 4314.7 | 15193 | 3.0 | Other |
enq: TX - row lock contention | 3,531 | 4076.2 | 1154 | 2.8 | Application |
latch free | 33 | 2768.7 | 83899 | 1.9 | Other |
reliable message | 140,434 | 2431.1 | 17 | 1.7 | Other |
DFS lock handle | 306 | 1969.3 | 6436 | 1.4 | Other |
DB CPU | 1204 | .8 | |||
enq: PR - contention | 6 | 1022.6 | 170433 | .7 | Other |