Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: package compilation hangs

Re: package compilation hangs

From: <jaysingh1_at_optonline.net>
Date: Tue, 31 Aug 2004 16:09:55 -0400
Message-id: <65e058662bee.662bee65e058@optonline.net>


Govindan,

Thanks for ur response.

We do user JDBC OCI driver (froma ppserver ) to access this PL/SQL package. As you mentioned that Java application might have accessed this package while compiling this package.

This particular session (SID=667) is active(checked gv$session).

How to fix this?

> 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
> > -----------------------------------------------------------------
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
>



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
-----------------------------------------------------------------
Received on Tue Aug 31 2004 - 15:05:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US