How to solve enq: PS - contention wait event in oracle 11gr2
OS: Linux
DB: oracle 11g R2
RAC: 3 node
One of the query in AWR and ADDM shows with enq: PS - contention wait event and ADDM Rationale is "
Waiting for event "enq: PS - contention" in wait class "Other" accounted
for 95% of the database time spent in processing the SQL statement with
SQL_ID"
It is simple SQL statement and only one table is involved with some where clauses.
table is partitioned table
Can someone please suggest how to solve this ?