enq: PS - contention

[herta]

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

[Brian Peasland]

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
d...@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

[DA Morgan]

herta wrote:
> One of our RAC databases currently shows high values for the "enq: PS
> - contention" wait event on two instances out of four:
>

> 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

google "PS - contention" produced 74 hits. Where were you searching?
--
Daniel A. Morgan
University of Washington
damo...@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

[herta]

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

[herta]

On Jun 13, 5:30 pm, DA Morgan <damor...@psoug.org> 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:
>
> > 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
>
> google "PS - contention" produced 74 hits. Where were you searching?
> --
> Daniel A. Morgan
> University of Washington

> damor...@x.washington.edu (replace x with u to respond)

> Puget Sound Oracle Users Groupwww.psoug.org

I had looked through the Oracle manuals (Master Index and Performance
guide), I had browsed the internet using "enq: PS - contention", which
produced 55 hits (none of which explained what the event meant), I
looked through metalink. Given the time pressure on the project we're
conducting (which had nothing to do with this database), I thought
this post was justified.

Not everyone is too lazy to do some searching before posting, Daniel.

[DA Morgan]

herta wrote:

> I had looked through the Oracle manuals (Master Index and Performance
> guide), I had browsed the internet using "enq: PS - contention", which
> produced 55 hits (none of which explained what the event meant), I
> looked through metalink. Given the time pressure on the project we're
> conducting (which had nothing to do with this database), I thought
> this post was justified.
>
> Not everyone is too lazy to do some searching before posting, Daniel.

I probably shouldn't say this out loud ... but ... I generally go to
google with such matters before I go to the Oracle docs.

--
Daniel A. Morgan
University of Washington

damo...@x.washington.edu (replace x with u to respond)