Re: about "cursor: pin S wait on X" wait event.
From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 27 Aug 2008 20:09:09 +0200
Message-ID: <48b5984e$0$197$e4fe514c@news.xs4all.nl>
Date: Wed, 27 Aug 2008 20:09:09 +0200
Message-ID: <48b5984e$0$197$e4fe514c@news.xs4all.nl>
"Helma" <helma.vinke_at_hotmail.com> schreef in bericht
news:557bdb59-e225-4844-9b5c-96e897673ecb_at_r15g2000prh.googlegroups.com...
> Subject: Bug 5907779 - Self deadlock hang on "cursor: pin S wait on
> X" (typically from DBMS_STATS)
> Note:5907779.8
>
> a bug on 10.2.0.3.
In spite of the docs, we see a lot of "cursor: pin S wait on X" wait events
occurring in a 10.2.0.4 db as well, causing (according to RDA/AWR reports)
the main portion of out wait events.
We are looking at it right now, will report back!
Shakespeare Received on Wed Aug 27 2008 - 13:09:09 CDT