Oracle Database - Redo Size statistics

Card Puncher Data Processing


The redo size statistics shows how much redo log your statement generated when executed.

Bulk Operation


The redo size statistics is most useful when judging the efficiency of large bulk operations with statements as :


The amount of redo generated by the statements :


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.

Discover More
Sql Developer Autotrace
Oracle Database - Autotrace

Autotrace is: a system variable of sql plus can also be found in SQL Developer AUTOTRACE provides you: an execution plan (such as explain plan) and some important regarding its actual execution....
Card Puncher Data Processing
Oracle Database - Session Statistics (V$SESSTAT)

The second part of the autotrace output are a part of the session statistics. V recursive_calls : Number of SQL...

Share this page:
Follow us:
Task Runner