I have a number of procedure sets that must be executed sequentially.
I have ProcA1, ProcA2, ProcA3, ProcA4...
When I run these separately within a SQLPlus session, like this:
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:
They will take FAR longer, and sometimes will not complete for hours.