Oracle RAC 3 nodes | 11.2.0.3 | High TX Index contention & Cluster waits
I am working on performance optimization of load run. When it runs TX Index contention waits goes high. Database is able to sustain till medium load like 15k users but as soon as it reaches more than 20, waits on TX starts going high and database goes in hang state.
Here are some stats from AWR. Please share insight if anyone have come across such problem. Thanks a lot in advance.
| Host Name | Platform | CPUs | Cores | Sockets | Memory (GB) |
|---|---|---|---|---|---|
| XXXXXXXXXX | Linux x86 64-bit | 32 | 16 | 2 | 125.94 |
| Snap Id | Snap Time | Sessions | Cursors/Session | |
|---|---|---|---|---|
| Begin Snap: | 4034 | 15-Dec-15 10:00:02 | 1618 | 50.9 |
| End Snap: | 4035 | 15-Dec-15 10:15:24 | 2035 | 76.2 |
| Elapsed: | 15.37 (mins) | |||
| DB Time: | 8,665.51 (mins) |
Tagged:
0