Drop index is haning because of "library cache lock"

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Thu, 12 May 2005 11:32:28 -0400
Message-ID: <f09dd62805051208326e7f82fc@mail.gmail.com>

Drop index is waiting for the library cache lock as per the the trace file below.
How to map the p1 and p2 parameters to identify who is blocking this object= ?

I don't see anything in gv$lock.

select p1raw,p2raw,p3raw from gv$session_wait where event=3D'library cache=  lock'
P1RAW P2RAW P3RAW =20

---------------- ---------------- ----------------

00000004021212F8 00000004011FF250 00000000000005DD 1 row selected
=20
WAIT #3: nam=3D'library cache lock' ela=3D 507738 p1=3D17214608120 p2=3D17616981672 p3=3D1501
WAIT #3: nam=3D'library cache lock' ela=3D 507952 p1=3D17214608120 p2=3D17616981672 p3=3D1501
WAIT #3: nam=3D'library cache lock' ela=3D 507435 p1=3D17214608120 p2=3D17616981672 p3=3D1501

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

Received on Thu May 12 2005 - 11:37:00 CDT