"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@xxxxxxxxx> 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??
