RE: RE: package compilation hangs
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 1 Sep 2004 10:15:17 -0400
Did you cancel your first compile attempt before you tried just compiling
the body?
Being that it is now the next day, what did you do to resolve this? We
would have probably restricted the system, killed all user sessions,
compiled, and then unrestricted the system if we could not just clear out
the using sessions.
Raj and a couple other posters have posted links to scripts to find the
using sessions but I think you can find this just by querying v$access where
object = package_name.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
jaysingh1@xxxxxxxxxxxxx
Sent: Tuesday, August 31, 2004 4:20 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: RE: package compilation hangs
We already tried "alter package x compile body" but no luck. Still it hangs.
----- Original Message -----
From: "Powell, Mark D" <mark.powell@xxxxxxx>
Date: Tuesday, August 31, 2004 4:12 pm
Subject: RE: package compilation 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@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
-----------------------------------------------------------------
Other related posts:
