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. -- Mladen Gogala A & E TV Network Ext. 1216 > -----Original Message----- > From: jaysingh1@xxxxxxxxxxxxx [mailto:jaysingh1@xxxxxxxxxxxxx] > Sent: Tuesday, August 31, 2004 3:49 PM > To: oracle-l@xxxxxxxxxxxxx > Subject: package compilation hangs > Now we are trying to compile the package and it hangs. ---------------------------------------------------------------- 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 http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------