I am running TPCE workload on oracle 122 and during the run seeing high waits on "cursor mutex X"
Top 10 Foreground Events by Total Wait Time
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Total Wait Avg % DB Wait
Event Waits Time (sec) Wait time Class
------------------------------ ----------- ---------- --------- ------ --------
cursor: mutex X 2.06472E+08 150.4K 728.34us 42.7 Concurre
DB CPU 50.2K 14.2
db file sequential read 10,884,654 8629.8 792.84us 2.5 User I/O
cursor: pin S 7,532,508 8571.8 1.14ms 2.4 Concurre
cursor: mutex S 2,973,827 3451.4 1.16ms 1.0 Concurre
PGA memory operation 34,155,412 3067.9 89.82us .9 Other
library cache: mutex X 4,182,588 1260.3 301.32us .4 Concurre
High wait time on "Cursor Stat" mutex
Here I am attaching AWR report,
Can someone help me on troubleshooting this?
Regards
Bhargava