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

Home -> Community -> Usenet -> c.d.o.server -> Re: Bulk update performance in Oracle 7.2

Re: Bulk update performance in Oracle 7.2

From: Madhu Cherukuri <Madhu.Cherukuri_at_usa.net>
Date: 5 Nov 1998 00:08:39 GMT
Message-ID: <3640ECBB.511F4862@usa.net>


I strongly suggest writing a Pro*C (It's very simple update) or atleast PL/SQL code to read the records and update them record by record. This will not require big rollback segment if you commit after some updates (like 1000 records) Also, I bet it will be faster with Pro*C. You can also split this update into pieces and update at your convenience. Ofcourse, if these update columns are indexes, you can drop them temporarily and rebuild them after update. No archive mode also make it faster

HTH Madhu Cherukuri

ajayanand_at_my-dejanews.com wrote:

> Hi!
>
> Could anyone recommend some ideas for bulk updation for better performance.
>
> I am using Oracle 7.2 and am updating 9 millon rows. The updation is for 2
> columns where the size for the new data would be smaller than existing data.
> e.g 15976.000243 will now be stored as 15976.0003.
>
> I am trying :
> 1. Using a big rollback.
> 2. Disable constraints/index
> 3. Locking table exclusively
> 4. No archive
> 5. Update
>
> Any suggestions.Thanks
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Wed Nov 04 1998 - 18:08:39 CST

Original text of this message

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