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: Update takes insanely long time

Re: Update takes insanely long time

From: fumi <fumi_at_tpts5.seed.net.tw>
Date: 11 Dec 1999 05:37:13 GMT
Message-ID: <82snu9$p88$2@news.seed.net.tw>

Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote in message news:38503319.90AF7F19_at_abbnm.com...
> Hi gurus,
> I have a question for you all. One of my developers is trying to
> update a table with around
> 16500 records . She is trying a very simple update statement
> update tablename set column1 = 'N' where column1 = 'Y'
> She has around 12500 records which will be affected.
> It has taken around 16 hours now for this simple operation. Other
> tables on the same
> instance do not have any problems for similar updates.
> There were about 35 constraints on this table which I disable hoping
>
> to do better this time
> without any success. Am I missing something obvious ? Should I be
> concerned about anything else ??
>
> Any comments,
> suggestions , ideas will be appreciated.

  1. Try to identify whether she was waiting for someone to release locks.
  2. If column1 is indexed, drop the indexes before update!
Received on Fri Dec 10 1999 - 23:37:13 CST

Original text of this message

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