Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: select question

Re: select question

From: music4 <music4_at_163.net>
Date: Tue, 18 Mar 2003 11:52:56 +0800
Message-ID: <b5657f$b4h@netnews.proxy.lucent.com>

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US