Re: Creating Packages hangs... forEVer.

From: Ryan January <rjanuary_at_gmail.com>
Date: Thu, 20 Aug 2015 08:54:54 -0500
Message-Id: <0261EF3A-8BC3-41F8-B9CB-B0A863854623_at_gmail.com>

"it seems to hang forever... although in reality it does finish eventually." To me it sounds like you're waiting on something. ;) What do your session's wait events show?

"I can't stop the other users that may be using their own versions of the package as this is a production system for the respective clients. The wait is becoming a problem for our upgrades." Have you considered edition based redefinition? (docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#ADFNS020 <http://docs.oracle.com/cd/E11882_01/appdev.112/e41502/adfns_editions.htm#ADFNS020>)

> On Aug 19, 2015, at 4:06 PM, David Hicken <utahtoad_at_gmail.com> wrote:
>
> Oracle 11.2.0.4
> RHEL 5 or 6
>
> I have a situation where we have clients running an application. The code in each of their schemas may or may not be the same version as each other, but they are all similar in structure and objects.
>
> My issue is that when I issue a "CREATE OR REPLACE PACKAGE BODY" command, it seems to hang forever... although in reality it does finish eventually. The wait that is being shown in the DB "SQL*Net more data from client". It can take literally up to hours of waiting. I am running the .sql file from a remote client sqlplus. The actual package is about 3500 lines long, and approximately 150K in size.
>
> I've tried dropping the package and/or package body.
>
> I can't stop the other users that may be using their own versions of the package as this is a production system for the respective clients. The wait is becoming a problem for our upgrades.
>
> Any ideas??

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 20 2015 - 15:54:54 CEST