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. |