Hello all,

I have a number of procedure sets that must be executed sequentially.
For example:
I have ProcA1, ProcA2, ProcA3, ProcA4...
When I run these separately within a SQLPlus session, like this:
exec ProcA1;
They will each complete in a reasonable amount of time (10 to 15 minutes) -
which is just what I expect.
If I run them this way:
exec ProcA1;
exec ProcA2;
exec ProcA3;
They will take FAR longer, and sometimes will not complete for hours.

Any ideas?

Red Hat Advanced Server 2.?