exp hangs on library cache mutex X

From: Schauss, Peter (ESS) <"Schauss,>
Date: Thu, 24 Jul 2014 17:20:34 +0000
Message-ID: <8AE45871F749FC4CBBE053CF2F8A493C11C5D40A_at_XMBVAG74.northgrum.com>

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

Received on Thu Jul 24 2014 - 19:20:34 CEST