RE: EXT :Re: exp hangs on library cache mutex X
- From: "Schauss, Peter (ESS)" <peter.schauss@xxxxxxx>
- To: Seth Miller <sethmiller.sm@xxxxxxxxx>
- Date: Fri, 25 Jul 2014 18:24:32 +0000
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@xxxxxxxxx]
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@xxxxxxx<mailto:peter.schauss@xxxxxxx>> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » RE: EXT :Re: exp hangs on library cache mutex X - Schauss, Peter (ESS)
