8.11 V$INSTANCE_RECOVERY
V$INSTANCE_RECOVERY
monitors the mechanisms available to users to limit recovery I/O. Those mechanisms are:
-
Set the
LOG_CHECKPOINT_TIMEOUT
initialization parameter -
Set the
LOG_CHECKPOINT_INTERVAL
initialization parameter -
Set the
FAST_START_MTTR_TARGET
initialization parameter -
Set the size of the smallest redo log
Column | Datatype | Description |
---|---|---|
|
|
Number of dirty buffers in the buffer cache. |
|
|
Current actual number of redo blocks required for recovery |
|
|
Current target number of redo blocks that must be processed for recovery. This value is the minimum value of the following 3 columns, and identifies which of the 3 user-defined limits determines checkpointing. |
|
|
Maximum number of redo blocks required to guarantee that a log switch does not occur before the checkpoint completes. |
|
|
Number of redo blocks that need to be processed during recovery to satisfy the |
|
|
Number of redo blocks that need to be processed during recovery to satisfy the |
|
|
This column is obsolete and maintained for backward compatibility. The value of this column is always null. |
|
|
Effective MTTR (mean time to recover) target value in seconds. The |
|
|
Current estimated mean time to recover (MTTR) based on the number of dirty buffers and log blocks. Basically, this value tells you how long you could expect recovery to take based on the work your system is doing right now. |
|
|
Number of blocks written by checkpoint writes |
|
|
Redo log file size (in megabytes) that is considered optimal based on the current setting of |
|
|
Estimated time (in seconds) that the cluster would become partially available should this instance fail. This column is only meaningful in an Oracle Real Application Clusters (Oracle RAC) environment. In a non-Oracle RAC environment, the value of this column is null. |
|
|
Number of writes driven by the |
|
|
Number of writes driven by the smallest redo log file size |
|
|
Number of writes driven by the |
|
|
Number of writes driven by other reasons (such as the deprecated |
|
|
Number of writes due to auto-tune checkpointing |
|
|
Number of writes due to full thread checkpoints |
|
|
The ID of the container to which the data pertains. Possible values include:
|