Re: Re: RE: package compilation hangs

From: <tim_at_sagelogix.com>
Date: Tue, 31 Aug 2004 14:30:20 -0600 (MDT)
Message-ID: <2847211.1093984220246.JavaMail.oracle@ocs.sagelogix.com>

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_at_freelists.org> 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_at_sagelogix.com>; 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_at_freelists.org
Delivered-To: oracle-l_at_freelists.org
Received: from localhost (localhost [127.0.0.1])

	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF9C072D194
	for <oracle-l_at_freelists.org>; 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_at_freelists.org>; 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_at_freelists.org>; 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_at_mta10.srv.hcvlny.cv.net> for oracle-l_at_freelists.org; 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_at_mstr8.srv.hcvlny.cv.net> for oracle-l_at_freelists.org; 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_at_optonline.net
Subject: Re: RE: package compilation hangs To: oracle-l_at_freelists.org
Message-id: <663ec06685f1.6685f1663ec0_at_optonline.net> 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_at_freelists.org
Errors-To: oracle-l-bounce_at_freelists.org X-original-sender: jaysingh1_at_optonline.net Precedence: normal
Reply-To: oracle-l_at_freelists.org

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_at_eds.com> 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_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:27:14 CDT