Oracle Database - Redo Size statistics
About
The redo size statistics shows how much redo log your statement generated when executed.
Articles Related
Bulk Operation
INSERT
The redo size statistics is most useful when judging the efficiency of large bulk operations with statements as :
- or CREATE TABLE AS SELECT (CTAS)
MERGE, UPDATE, DELETE
The amount of redo generated by the statements :
- MERGE
- UPDATE
- DELETE
will be in many case outside of our control.
If you perform these operations with as few index enabled as possible, you can reduce the amount of redo generated, but you will have to rebuild those disabled indexes. This is generally practical only in datawarehouse when you are performing large data loads.