Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: a performance question
"Jay" <jwu_at_nctr.fda.gov> wrote in message
news:_AFea.60$N5.4917_at_mencken.net.nih.gov...
> I have a table that has about 100,000 records. The primary key has type of
> number. When I did a 'update column=value where primary_key > number and
> primary < number (about 100 records), it took about 15 minutes. Our
database
> server is a capable machine and this slow update is totally upacceptible.
> After we dropped the table and recreated it, the same update took less
than
> 1 second. I am wondering what change within the datase has made the huge
> performance difference. Thanks.
>
15 *minutes*? No performance is this slow.
Was it waiting on a lock?
Regards,
Paul
Received on Fri Mar 21 2003 - 15:16:26 CST