improving performance of update statement
We use oracle 22.214.171.124 and solaris 2.8.
We have have 8 CPU each 750 Mhz. We are doing a bulk update using Pro*C. Each batch does an update of 50K. This is taking close to 8.5 Min. We are passing the where condition values using an Array.
The table is very big, and has some old data. We are planing to purge all the old data. Apart from this is it possible to improve the performance of the update statement. Something like parallel update or direct update which would improve the update speed.
Can u please guide to any documentation on this or provide some help would be greatly appreciated.