RE: EXT :Re: exp hangs on library cache mutex X

From: Schauss, Peter (ESS) <"Schauss,>
Date: Fri, 25 Jul 2014 18:24:32 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C11C5DA03_at_XMBVAG74.northgrum.com>

Seth,

I must have mistyped it in the email because when I plugged 141792 into the query it returns 2 instead of 22.

Thanks,
Peter Schauss

From: Seth Miller [mailto:sethmiller.sm_at_gmail.com] Sent: Thursday, July 24, 2014 4:18 PM
To: Schauss, Peter (ESS)
Cc: oracle-l
Subject: EXT :Re: exp hangs on library cache mutex X

Peter,

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

 FROM dual; (where P2 = 141792)

Seth Miller

On Thu, Jul 24, 2014 at 12:20 PM, Schauss, Peter (ESS) <peter.schauss_at_ngc.com<mailto: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 Received on Fri Jul 25 2014 - 20:24:32 CEST