Re: package compilation hangs

That means there is some active session which is holding the package in
memory and has not released it.
Check from v$session for active sessions.  We run into this frequently
in development though not in production. The developers here use JDBC
drivers and when a pkg.is being recompiled by the pl/sql developer and
simultaneously accessed by the JDBC this occurs. Check if you are
running into any similar env

HTH
GovindanK


On Tue, 31 Aug 2004 15:49:14 -0400, jaysingh1@xxxxxxxxxxxxx said:
> Hi All,
> 
> The package BODY status became invalid because of the object
> modification(another package) refered in the package body.
> 
> Now we are trying to compile the package and it hangs.
> 
> Checked DBA_DDL_LOCKS 
> select owner,session_id,mode_held from dba_ddl_locks where
> name='SEARCH_PKG';
> 
> OWNER,SESSION_ID,MODE_HELD
> ----- ---------- ----------
> REPORTS,667,Share
> PUBLIC,667,Share
> ATG56,667,Share
> REPORTS,667,None
> REPORTS,968,Exclusive
> 
> 
> If I kill session_id 968, something else appears here. I did this
> exercise 4 times.
> What could be wrong here.
> 
> 
> select * from gv$access where object='SEARCH_PKG' is returning more than
> 50 records.
> 
> Could someone shed some light on this?
> 
> Thanks
> Jay
> 
> 
> 
> 
> ----------------------------------------------------------------
> 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: