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

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_at_llnl.gov

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=
>?

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