Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: package compilation hangs

RE: package compilation hangs

From: Gogala, Mladen <Mladen.Gogala_at_aetn.com>
Date: Tue, 31 Aug 2004 15:54:44 -0400
Message-ID: <30462D80AA52E74698512ADCC4F7EAA312239716@EXCHANGE>


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_at_optonline.net [mailto:jaysingh1_at_optonline.net]
> Sent: Tuesday, August 31, 2004 3:49 PM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org 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 -----------------------------------------------------------------
Received on Tue Aug 31 2004 - 14:50:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US