Re: Creating Packages hangs... forEVer.

What version of SQL*Plus client? Since the database says it is waiting for more data from client, perhaps it could be an issue with an older SQL*Plus that may not be able to handle large code so well?

Are you able to run the script from a local client on the database server just once for testing? To discover if it is the "remote" aspect that gives problems? Maybe the rather large "echo" of the code, like Rich J suggests?

How fast does smaller packages install? Is it only this single large package that has the problem? Are there other as large packages that do not have the problem?

Have you tried renaming the package in the script to something that does not exist in any schema and see if it installs quickly? To discover whether it actually is the "multiple copies of identically named packages in multiple packages" that might be a problem or not?

Just some things to try out ;-)

Regards

Kim Berg Hansen

http://dspsd.blogspot.com
kibeha_at_gmail.com
_at_kibeha

On Wed, Aug 19, 2015 at 11: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