Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: select question
> Have you looked into why your update is taking so long? If not, should do
an
> "explain plan for" or similar type check to find why it's so slow.
>
When I said "slow", I just meant "relatively slow", and that could not meet
the performance requirement.
> Is this loop being run by multiple threads or just one? If multiple
threads
> are executing this loop simultaneously you could have some issues with
this
> unless there is some locking of some sort happening that is outside the
> scope of this code snippet.
>
I have only one thread to do this loop.
Received on Mon Mar 17 2003 - 21:52:56 CST