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??