Re: Huge Disk Write while performing delete operation
A single transaction touching 1 million rows?
* The rows to be deleted have to be copied into the transaction log in case you ROLLBACK, or the system crashes and a recovery is needed.
* The indexes have to be updated.
* Blocks will be coalesced.
* If you have Row Based Replication, then there is the stuff in the binlog.
Etc.
Subject
Views
Written By
Posted
2884
June 10, 2010 10:17PM
Re: Huge Disk Write while performing delete operation
1568
June 12, 2010 12:50AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.