Re: SQLPlus session question

Karsten,

First of all, thanks for answering...

Yes. The procedures do contain Updates.

I should clarify though, the order of procedures is more like: ...
exec ProcA1;
commit;
exec ProcA2;
commit;
exec ProcA3;
commit;
...

Does this make any difference?

I assume that any row locks would be freed on commit, but I'm no expert.

Thanks again,
Tim

"Karsten Farrell" <kfarrell_at_belgariad.com> wrote in message news:iTsD9.2693$I71.80596017_at_newssvr14.news.prodigy.com...
> 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 - 21:19:13 CST