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: RE: package compilation hangs

Re: RE: package compilation hangs

From: <jaysingh1_at_optonline.net>
Date: Tue, 31 Aug 2004 16:20:20 -0400
Message-id: <663ec06685f1.6685f1663ec0@optonline.net>


We already tried "alter package x compile body" but no luck. Still it hangs.

> Jay, to compile a package Oracle takes an exclusive lock on the
> package.Oracle cannot get the exclusive lock if the package is in
> use. You should
> generally not make changes to tables referenced in stored code
> that itself
> is referenced by other stored code except during periods of very
> low usage
> or maintenance windows.
>
> If you must make the change during busy periods you should try to
> stop or
> get the users out of the affected applications at the time of the
> change.Then when you go to recompile invalided packages only
> recompile the body if
> the specification was not changed since recompiling the
> specification can
> cause cascading invalidations.
>
> If you want long enough the re-compile may well work, but you
> might try
> canceling it and issuing just a recompile on the body if you made this
> mistake.
>
> alter package x compile [spec and body] verse alter package x
> compile body
> [to just do the body and limit cascading if the spec was not
> changed]
>



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 - 15:17:17 CDT

Original text of this message

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