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: herta <herta.vandeneynde_at_gmail.com>
Date: Wed, 13 Jun 2007 18:17:25 -0000
Message-ID: <1181758645.082750.226820@x35g2000prf.googlegroups.com>


On Jun 13, 5:29 pm, Brian Peasland <d..._at_nospam.peasland.net> wrote:
> 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
>

Thanks, Brian. Yes, that did help. Apparently the stats gathering job, which uses parallelism, got stuck on one of the tables (haven't had time to investigate yet).

Kind regards,

Herta Received on Wed Jun 13 2007 - 13:17:25 CDT

Original text of this message

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