Gogala, Thanks for your immediate response. <<SELECT * FROM V$SESSION_WAIT where sid= 667 >> If I kill sid 667, some other session appears in DBA_DDL_LOCKS table for that package. V$SESSION_WAIT says that it is waiting fro "library cache pin" We cannot restart the db. It is 24/7 but OPS environment. Thanks Jay ----- Original Message ----- From: "Gogala, Mladen" <Mladen.Gogala@xxxxxxxx> Date: Tuesday, August 31, 2004 3:54 pm Subject: RE: package compilation hangs > Did you check V$SESSION_WAIT to see what is it waiting for? > It will give you exactly the lock you are waiting for. > Kill the session holding the lock and re-try. If that > doesn't help, connect as sysdba and type > the following: > STARTUP FORCE RESTRICT > That will almost guarantee that you can recompile the package. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------