RE: RE: package compilation hangs

Would you mind posting the results of:
select 
username, l.sid, l.type, id1,id2,lmode, request, ctime, block
from 
v$lock l, v$session s
where
l.sid=s.sid 
order by block,7
/



-----Original Message-----
From: jaysingh1@xxxxxxxxxxxxx [mailto: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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: