Re: HELP :Updating a table with 3 million records...

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 11 Jan 1999 11:39:16 +0800
Message-ID: <36997264.4223@bhp.com.au>

Kris wrote:
>
> Hi All,
>
> We are running into a serious problem. We hae a table with 3 million records
> and we have to do a ltrim , rtrim on one of the columns. I tried a simple
> update statement and it took ages. I aborted and decided to run using a
> PL/SQL script.
>
> I loaded the 3 million in a cursor and updated the record and commited. This
> again is taking more than 23 hours and has finished around 2 million
> records. Now I am rewriting my script to load the records that have not been
> trimmed and update them, it is the same scenario, takes ages.
>
> I tweaked my init.ora parameter to a large database. Unfortunately my
> db_block_size is 2k. We are running oralce8.0 on NT with 256M and dual
> processor ....
>
> Any suggestions to speeden the process. Any help would be greatly
> appreciated.
>
> Krishnan
> e-mail:krishnan_at_cdgpd.com

23 hours seems very long...Maybe check your alert log for "Checkpoint not complete" messages. If you find any, then you need to have larger or more redo logs...

Cheers
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Sun Jan 10 1999 - 21:39:16 CST