High Cluster Wait events and how to resolve those in 11g
While application team is doing their performance load test. Observed the high cluster event events in 2 node RAC do. Help me to resolve those.
Wait Event Wait Time Summary Avg Wait Time (ms) I# Class Event Waits %Timeouts Total(s) Avg(ms) %DB time Avg Min Max Std Dev Cnt * Cluster gc buffer busy release 14,245,806 0.00 143,487.48 10.07 30.54 10.07 10.05 10.10 0.03 2
* Cluster gc buffer busy acquire 19,155,916 0.02 88,834.79 4.64 18.91 4.64 4.54 4.73 0.13 2
* Concurrency enq: TX - index contention 4,114,642 0.00 70,870.89 17.22 15.09 17.20 16.49 17.92 1.01 2
* DB CPU 51,489.66 10.96 2
* Cluster gc current block busy 5,864,541 0.00 31,235.70 5.33 6.65 5.33 5.22 5.43 0.15 2
* Concurrency buffer busy waits 8,278,278 0.00 27,031.44 3.27 5.75 3.27 3.15 3.40 0.17 2
* User I/O db file sequential read 4,623,340 0.00 14,780.10 3.20 3.15 3.77 2.78 4.77 1.41 2
* Other gcs log flush sync 31,890,519 1.28 12,141.82 0.38 2.58 0.38 0.38 0.38 0.01 2
* Cluster gc cr block busy 1,637,131 0.00 11,147.99 6.81 2.37 6.79 6.66 6.92 0.19 2
* Commit log file sync 608,336 0.00 10,334.72 16.99 2.20 16.96 16.11 17.82 1.20 2 1 Cluster gc buffer busy release 7,539,229 0.00 75,776.18 10.05 30.80