Dear Experts,
I am getting the following section in the ADDM:
FINDING 1: 80% impact (7733 seconds)
------------------------------------
Contention for latches related to the shared pool was consuming significant
database time.
NO RECOMMENDATIONS AVAILABLE
ADDITIONAL INFORMATION:
Waits for "latch: library cache" amounted to 43% of database time.
Waits for "latch: shared pool" amounted to 36% of database time.
SYMPTOMS THAT LED TO THE FINDING:
SYMPTOM: Wait class "Concurrency" was consuming significant database
time. (82% impact [7848 seconds])
How do we check which session/sql is causing the issue? What action can be taken to resolve this?
Thanks
Anand