4.335 DBA_HIST_INSTANCE_RECOVERY
DBA_HIST_INSTANCE_RECOVERY
displays the historical monitoring of the mechanisms available to the user to limit recovery I/O.
This view contains snapshots of V$INSTANCE_RECOVERY
.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Unique snapshot ID |
|
|
|
Database ID for the snapshot |
|
|
|
Instance number for the snapshot |
|
|
|
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 In such cases, the |
|
|
|
Current estimated mean time to recover (MTTR) based on the number of dirty buffers and log blocks ( |
|
|
|
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 the 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 database ID of the PDB for the sampled session |
|
|
|
The ID of the container that
|
See Also: