RE: cursor: pin S wait on X

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Fri, 28 Apr 2006 12:59:07 -0500
Message-ID: <565F609E6D736D439837F1A1A797F34171D3E2@ADMINMAIL1.ui.uillinois.edu>

No, but thanks for asking. The "mega-slowness" is a completely different issue, for which I am still befuddled.

This mutex problem is something new in a test db for 10.2.0.2 (hence, your link to Tanel's note was helpful in that regards). Still trying to figure out how we arrived at 30 processes waiting on this mutex pin.

-----Original Message-----
From: Ray Stell [mailto:stellr_at_cns.vt.edu] Sent: Friday, April 28, 2006 12:55 PM
To: Schultz, Charles
Cc: oracle-l
Subject: Re: cursor: pin S wait on X

Be sure to post your findings. Is this at the root of your 10g mega-slowness?

On Fri, Apr 28, 2006 at 12:05:22PM -0500, Schultz, Charles wrote:
> That information is good, but I still do not know how to turn
> 000000A100000000 into a SID. I am reading up on askTom about bitand

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 28 2006 - 12:59:07 CDT