package compilation hangs
- From: jaysingh1@xxxxxxxxxxxxx
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 31 Aug 2004 15:49:14 -0400
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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
