Re: exp hangs on library cache mutex X

Did you run the wrong sql statement or did you copy it to your email incorrectly? The P2 value you used in the select statement is not the same as your query result.

library cache: mutex X
p1 text: idn
p1: 72788
p2 text: value
p2: *1441792*

SELECT decode(trunc(&&P2/4294967296),
           0,trunc(&&P2/65536),
             trunc(&&P2/4294967296)) SID_HOLDING_MUTEX

Seth Miller

On Thu, Jul 24, 2014 at 12:20 PM, Schauss, Peter (ESS) < peter.schauss_at_ngc.com> wrote:

> Oracle 11.2.0.3 on Windows Server 2003 sp2 32 bit.
>
> I have a nightly job which hangs while running (full=y grants=y) on one of
> my instances.
>
> I look at v$session_wait for the session and I get:
>
> library cache: mutex X
> p1 text: idn
> p1: 72788
> p2 text: value
> p2: 1441792
>
> Based on MOS note 1298015.1 I ran
>
> SELECT decode(trunc(&&P2/4294967296),
> 0,trunc(&&P2/65536),
> trunc(&&P2/4294967296)) SID_HOLDING_MUTEX
> FROM dual; (where P2 = 141792)
>
> To get the sid holding the mutex which, in this case was 22 = M00
>
> V$session_wait gives the following for sid 22:
> library cache; mutex
> p1 idn = 3144883284
> p2 value = 10616832
> sid = 162
>
> But there is no sid 162.
>
> Am I interpreting this information correctly?
>
> Thanks,
> Peter Schauss
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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