Oracle: Why should I not commit after every record when updating a large table?

Question

Why should I not commit after every record when updating a large table Committing after every record does not hurt but its much efficient to commit after a batch of records like 5000 - 7000.

Answer 1

I would suggest that you set this range based on the size of your rollback segment.

Answer 2

1. Committing very frequently creates the error ORA-1555 (Snapshot too old)
2. Also, every commit operation involves writing into the database file in harddisk, which is slow and takes up lot of processor cycles, which will result in slower performance of database engine.