V$INSTANCE_RECOVERY

This view monitors the mechanisms available to users to limit recovery I/O. Those mechanisms are:

• Set the initialization parameter LOG_CHECKPOINT_TIMEOUT.

• Set the initialization parameter LOG_CHECKPOINT_INTERVAL.

• Set the initialization parameter FAST_START_IO_TARGET.

• Set the size of the smallest redo log.

  See Also: Oracle8i Designing and Tuning for Performance for more information on limiting recovery I/O. LOG_CHECKPOINT_INTERVAL. FAST_START_IO_TARGET.

  Column	Datatype	Description
  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.