http://www.ixora.com.au/scripts/sql/executing_packages.sql is what you are looking for. Plsql code cannot be compiled if it is being executed. This sql will list all the SIDs that are executing the code in question. Once the sessions listed are taken care of, you should be fine. Raj --- jaysingh1@xxxxxxxxxxxxx wrote: > 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 > ----------------------------------------------------------------- > ===== Best Regards Raj --------------------------------------------------------- select mandatory_disclaimer from company_requirements; _______________________________ Do you Yahoo!? Win 1 of 4,000 free domain names from Yahoo! Enter now. http://promotions.yahoo.com/goldrush ---------------------------------------------------------------- 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 -----------------------------------------------------------------