Re: enq: PS - contention

herta wrote:
> 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_TIMEOUTS
> TIME_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
>

Enqueue PS contention waits are your session waiting on Process Slaves (PS) for parallel processing. You will probably have another session waiting on "cursor: pin X" events. If so, see Bug no 5908030 on Metalink.

You may have to open a Service Request with Metalink to get this resolved.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com