Databases Reference
In-Depth Information
V$FIXED_TABLE
This view lists all
V$
and
X$
Dynamic Performance Views.
Fields
The most relevant view fields are as follows:
F
NAME
: The object name
F
OBJECT_ID
: The object identification number
F
TYPE
: The object type; can be
TABLE
or
VIEW
F
TABLE_NUM
: If the type is
TABLE
, it identifies the dynamic performance table
V$INSTANCE_RECOVERY
This view monitors the mechanisms available to the user/DBA to limit the I/O needed
for recovery.
Fields
The most relevant view fields are as follows:
F
RECOVERY_ESTIMATED_IOS
: The estimated number of data blocks to process
during recovery
F
ESTIMATED_MTTR
: The estimated time recovery based on the current system load
F
TARGET_MTTR
: The Mean Time To Recover (MTTR) target value in seconds
F
LOG_FILE_SIZE_REDO_BLKS
: The number of redo blocks required to be sure that
a log switch won't occur before the checkpoint completes
F
LOG_CHKPT_INTERVAL_REDO_BLKS
: The number of redo blocks that will be
processed during recovery to satisfy the
LOG_CHECKPOINT_INTERVAL
parameter
F
LOG_CHKPT_TIMEOUT_REDO_BLKS
: The number of redo blocks that will be
processed during recovery to satisfy the
LOG_CHECKPOINT_TIMEOUT
parameter
F
ACTUAL_REDO_BLKS
: The current number of redo blocks needed to recover
F
TARGET_REDO_BLKS
: The current target number of redo blocks that must be
processed for recovery