Tim C wrote:
> 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.
> HOWEVER:
> 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?
> Thanks,
> Tim
>
> Oracle 9.2.0.1.0
> Red Hat Advanced Server 2.?
>
Do the procedures contain UPDATE statements? You might be seeing the
effects of row locks.
Received on Fri Nov 22 2002 - 10:24:46 CST
