| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_at_optonline.net 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_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
> -----------------------------------------------------------------
-- 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 - 14:58:14 CDT
 |
 |