do it again, next time, see if the sid is a job. dbms_job.broken....kill, rinse, repeat. -----Original Message----- From: jaysingh1@xxxxxxxxxxxxx [mailto:jaysingh1@xxxxxxxxxxxxx] Sent: Tuesday, August 31, 2004 4:02 PM To: oracle-l@xxxxxxxxxxxxx Subject: Re: RE: package compilation hangs 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------