Please Help me Diagnose 'enq: TX - contention' with wait_class 'other'
I have a 5TB 11GR2 2 node RAC database where yesterday I experienced a significant amount of wait. I run AWR and ASH reports for the period and the top wait event was
'enq: TX - contention' and the wait class was 'other'
Top 5 Timed Foreground Events
| Event | Waits | Time(s) | Avg wait (ms) | % DB time | Wait Class |
|---|---|---|---|---|---|
| enq: TX - contention | 11,053 | 303,444 | 27454 | 57.03 | Other |
| enq: TX - row lock contention | 15,433 | 78,983 | 5118 | 14.85 | Application |
| cursor: mutex X | 35,931,692 | 54,399 | 2 | 10.22 | Concurrency |
| enq: TX - allocate ITL entry | 13,129 | 27,693 | 2109 | 5.21 | Configuration |
| cursor: mutex S | 22,063,676 | 16,917 | 1 | 3.18 | Concurrency |
Foreground Wait Class
- s - second, ms - millisecond - 1000th of a second
- ordered by wait time desc, waits desc
0