Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: enq: PS - contention

Re: enq: PS - contention

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Wed, 13 Jun 2007 10:29:08 -0500
Message-ID: <46700107$0$16303$88260bb3@free.teranews.com>


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
Received on Wed Jun 13 2007 - 10:29:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US