Re: Drop index is haning because of "library cache lock" - oracle-l - FreeLists

Re: Drop index is haning because of "library cache lock"

From: Andy Rivenes <arivenes@xxxxxxxx>
To: dba.orcl@xxxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 12 May 2005 09:39:57 -0700

Try the script libcache_lock.sql at www.appsdba.com/scripts_db.htm. This 
script is based on Oracle Note: 122793.1.

Andy Rivenes
arivenes@xxxxxxxx

At 08:32 AM 5/12/2005, Sami Seerangan wrote:
>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=
>?

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

References:
- Drop index is haning because of "library cache lock"
  - From: Sami Seerangan

Other related posts:

» Drop index is haning because of "library cache lock"
» Re: Drop index is haning because of "library cache lock"