Running Oracle 11.1 standard edition on Red Hat
I have a very large table; 400,000,000 rows. I need to update one field in each row.
I am committing every 5000 rows and writing a time stamp to a log file.
Each group of 5000 updates should be doing exactly the same amount of work.
Initially the commit timestamps are about 10 seconds apart.
The time per group gradually grows.
After about 500,000 rows the time per group of 5000 is up to 3 minutes.
I have tried stopping and restarting the the transaction.
It starts fast and then slows again.
Any help would be appreciated.
Dave Roth