RECOVERY_EXTIMATED_IOS 

NUMBER 

Estimated number of blocks that would be processed during recovery. This estimate is based on the FAST_START_IO_TARGET initialization parameter. The value is not meaningful unless that parameter is driving checkpointing behavior (see the TARGET_REDO_BLOCKS column below). 

ACTUAL_REDO_BLOCKS 

NUMBER 

The current actual number of redo blocks required for recovery. 

TARGET_REDO_BLOCKS 

NUMBER 

The current target number of redo blocks that must be processed for recovery. This value is the minimum of the following four columns, and indicates which of those four user-defined limits dominates checkpointing. 

LOG_FILE_SIZE_REDO_BLKS 

NUMBER 

Maximum number of redo blocks required to guarantee that a log switch does not occur before the checkpoint completes. 

LOG_CHKPT_TIMEOUT_REDO_BLKS 

NUMBER 

Number of redo blocks that need to be processed during recovery to satisfy the LOG_CHECKPOINT_TIMEOUT parameter. The value displayed is not meaningful unless that parameter has been set. 

LOG_CHKPT_INTERVAL_REDO_BLKS 

NUMBER 

Number of redo blocks that need to be processed during recovery to satisfy the LOG_CHECKPOINT_INTERVAL parameter. The value displayed is not meaningful unless that parameter has been set. 

FAST_START_IO_TARGET_REDO_BLKS 

NUMBER 

Number of redo blocks that need to be processed during recovery to satisfy the FAST_START_IO_TARGET parameter. The value displayed is not meaningful unless that parameter has been set.