Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> enq: PS - contention
One of our RAC databases currently shows high values for the "enq: PS
- contention" wait event on two instances out of four:
INST_ID EVENT TOTAL_WAITS TOTAL_TIMEOUTSTIME_WAITED AVERAGE_WAIT TIME_WAITED_MICRO EVENT_ID
---------- --------------------- ----------- -------------- ----------- ------------ ----------------- ---------- 4 enq: PS - contention 69854 0 2389 0 23890039 2071012023 3 enq: PS - contention 311544 144523 7487132 24 7.4871E+10 2071012023 2 enq: PS - contention 70269 8 2212 0 22115604 2071012023 1 enq: PS - contention 257011 147468 7639045 30 7.6390E+10 2071012023
I searched around, but cannot find any documentation on this wait event. What is this wait event? (A pointer to doc is fine as well.)
Kind regards,
Herta Received on Wed Jun 13 2007 - 04:14:42 CDT