Hi,
I'm very new to AWR reports. I started learning from the below link.
http://www.dbas-oracle.com/2013/05/10-steps-to-analyze-awr-report-in-oracle.html
6. Top 5 Timed Foreground Events
In the above section, the author mentioned "if wait class has value "Concurrency" then there could be some serious problem.".
In my AWR report I see wait class: Concurrency for Event: 'cursor: pin S wait on X'. More details for this event are below:
Event: cursor: pin S wait on X
Waits: 6,532
Total Wait Time (sec): 422.2
Wait Avg (ms): 65
% DB Time: 2.0
Wait Class: Concurrency.
Can someone please help me understand, what is the impact of concurrency and how do I find the root cause for this?
I'm using Windows 7 Enterprise
Oracle:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
"CORE 11.2.0.4.0 Production"
TNS for 64-bit Windows: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production