RE: cursor: pin S wait on X
- From: <Joel.Patterson@xxxxxxxxxxx>
- To: <grzegorzof@xxxxxxxxxx>
- Date: Tue, 9 Nov 2010 14:59:14 -0500
10.2.0.4. We plan on upgrading to 11gR2. (solaris 10)
I saw some bugs pertaining to 10.2.0.3...
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: Grzegorz Goryszewski [mailto:grzegorzof@xxxxxxxxxx]
Sent: Tuesday, November 09, 2010 2:45 PM
To: Patterson, Joel
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: cursor: pin S wait on X
W dniu 2010-11-09 20:26, Joel.Patterson@xxxxxxxxxxx pisze:
> This question is somewhat associated with my lsuosstats global area latch
> question recently posted.
>
> We were running a load test and so many of the queries where probably doing
> the exact same thing. So the event "cursor: pin S wait on X" which bubbled
> to the top.
>
> > From Tanel Poders web site: "A mutex differs from a latch in that there
> > would be many more requestors backed up on a latch, whereas a mutex in this
> > case protects just one cursor."
> Since this was a test, I am assuming that this is nothing to be concerned
> about now, but if I were to become concerned about it, does anyone know how
> they could approach this event specifically? Is there anything we can do
> about it now - because we are testing?
Hi,
which database version You talking about ?
There was some bugs related to that mutex .
Regards.
Greg
--
//www.freelists.org/webpage/oracle-l
Other related posts:
