Re: Re: RE: package compilation hangs

Search on the phrase "who_is_using" in MetaLink, to obtain the wrapped source 
for a stored procedure which will identify who is using the PL/SQL object you 
are trying to comple.


-- Attached file included as plaintext by Ecartis --
-- File: Re: RE: package compilation hangs

Return-Path: <oracle-l-bounce@xxxxxxxxxxxxx>
Received: from mail.sagelogix.com by ocs.sagelogix.com
        with ESMTP id 35284811093983785; Tue, 31 Aug 2004 14:23:05 -0600
Received: by mail.sagelogix.com (Postfix, from userid 16)
        id B4C26A8175; Tue, 31 Aug 2004 14:14:58 -0600 (MDT)
Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180])
        by mail.sagelogix.com (Postfix) with ESMTP id 9B34CA8102
        for <tim@xxxxxxxxxxxxx>; Tue, 31 Aug 2004 14:14:56 -0600 (MDT)
Received: from localhost (localhost [127.0.0.1])
        by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
        id E977972DB2B; Tue, 31 Aug 2004 15:20:09 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
 id 25613-10; Tue, 31 Aug 2004 15:20:09 -0500 (EST)
Received: from turing (localhost [127.0.0.1])
        by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP
        id 3617872D1D8; Tue, 31 Aug 2004 15:20:09 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 31 Aug 2004 15:18:43 -0500 
(EST)
X-Original-To: oracle-l@xxxxxxxxxxxxx
Delivered-To: oracle-l@xxxxxxxxxxxxx
Received: from localhost (localhost [127.0.0.1])
        by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP 
id CF9C072D194
        for <oracle-l@xxxxxxxxxxxxx>; Tue, 31 Aug 2004 15:18:42 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP
 id 22801-91 for <oracle-l@xxxxxxxxxxxxx>;
 Tue, 31 Aug 2004 15:18:42 -0500 (EST)
Received: from mta10.srv.hcvlny.cv.net (mta10.srv.hcvlny.cv.net [167.206.5.85])
        by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP 
id 81A0E72D17F
        for <oracle-l@xxxxxxxxxxxxx>; Tue, 31 Aug 2004 15:18:42 -0500 (EST)
Received: from oolsrv8.srv.hcvlny.cv.net
 (oolsrv8.srv.hcvlny.cv.net [167.206.5.23]) by mta10.srv.hcvlny.cv.net
 (iPlanet Messaging Server 5.2 HotFix 1.25 (built Mar  3 2004))
 with ESMTP id <0I3B00N92V5W2U@xxxxxxxxxxxxxxxxxxxxxxx> for
 oracle-l@xxxxxxxxxxxxx; Tue, 31 Aug 2004 16:20:20 -0400 (EDT)
Received: from optonline.net (localhost [127.0.0.1]) by mstr8.srv.hcvlny.cv.net
 (iPlanet Messaging Server 5.2 HotFix 1.25 (built Mar  3 2004))
 with ESMTP id <0I3B003IWV5WQK@xxxxxxxxxxxxxxxxxxxxxxx> for
 oracle-l@xxxxxxxxxxxxx; Tue, 31 Aug 2004 16:20:20 -0400 (EDT)
Received: from [167.206.5.47] (Forwarded-For: [208.131.51.19])
 by mstr8.srv.hcvlny.cv.net (mshttpd); Tue, 31 Aug 2004 16:20:20 -0400
Date: Tue, 31 Aug 2004 16:20:20 -0400
From: jaysingh1@xxxxxxxxxxxxx
Subject: Re: RE: package compilation hangs
To: oracle-l@xxxxxxxxxxxxx
Message-id: <663ec06685f1.6685f1663ec0@xxxxxxxxxxxxx>
MIME-version: 1.0
X-Mailer: iPlanet Messenger Express 5.2 HotFix 1.25 (built Mar  3 2004)
Content-type: text/plain; charset=us-ascii
Content-language: en
Content-Transfer-Encoding: 8bit
Content-disposition: inline
X-Accept-Language: en
Priority: normal
X-Virus-Scanned: by amavisd-new at freelists.org
X-archive-position: 8773
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@xxxxxxxxxxxxx
Errors-To: oracle-l-bounce@xxxxxxxxxxxxx
X-original-sender: jaysingh1@xxxxxxxxxxxxx
Precedence: normal
Reply-To: oracle-l@xxxxxxxxxxxxx
X-list: oracle-l
X-Virus-Scanned: by amavisd-new at freelists.org
X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on mail.sagelogix.com
X-Spam-Status: No, hits=0.5 required=3.0 tests=NO_REAL_NAME autolearn=no 
        version=2.63
X-Spam-Level: 

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: