Bulk update performance in Oracle 7.2

From: <ajayanand_at_my-dejanews.com>
Date: Wed, 04 Nov 1998 20:03:43 GMT
Message-ID: <71qbv0$lv8$1@nnrp1.dejanews.com>

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 - 14:03:43 CST