Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Bulk update performance in Oracle 7.2
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