Re: cursor: pin S wait on X

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Fri, 28 Apr 2006 11:40:25 -0700
Message-ID: <3b0f44a10604281140i5a46a690s996884131d3972a0@mail.gmail.com>

Charles:

Cursor: pin S wait on X is used like a replacement to library cache pin either during compiling the child or the execution of the KGL object. You see this wait when the mutex is held by the other session on X mode.

You can look the V$mutex_sleep views to find out the requesting session and blocking session and deal this issue like the same old library cache pin waits.

If you want the traditional library cache mechanism to be used for library cahce operations, you can turn this feature (!) off by setting the parameter _use_kks_mutex_pin to false. Other alternative is to look in the mutex_sleep view and find the locations of the waits. This will give a clear picture on which location it is waiting for that wait.

--

Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004 http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 28 2006 - 13:40:25 CDT