[Home] [Help] [Dependency Information]
Object Name: | V_$INSTANCE_RECOVERY |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECOVERY_ESTIMATED_IOS | NUMBER | |||
ACTUAL_REDO_BLKS | NUMBER | |||
TARGET_REDO_BLKS | NUMBER | |||
LOG_FILE_SIZE_REDO_BLKS | NUMBER | |||
LOG_CHKPT_TIMEOUT_REDO_BLKS | NUMBER | |||
LOG_CHKPT_INTERVAL_REDO_BLKS | NUMBER | |||
FAST_START_IO_TARGET_REDO_BLKS | NUMBER | |||
TARGET_MTTR | NUMBER | |||
ESTIMATED_MTTR | NUMBER | |||
CKPT_BLOCK_WRITES | NUMBER | |||
OPTIMAL_LOGFILE_SIZE | NUMBER | |||
ESTD_CLUSTER_AVAILABLE_TIME | NUMBER | |||
WRITES_MTTR | NUMBER | |||
WRITES_LOGFILE_SIZE | NUMBER | |||
WRITES_LOG_CHECKPOINT_SETTINGS | NUMBER | |||
WRITES_OTHER_SETTINGS | NUMBER | |||
WRITES_AUTOTUNE | NUMBER | |||
WRITES_FULL_THREAD_CKPT | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT RECOVERY_ESTIMATED_IOS
, ACTUAL_REDO_BLKS
, TARGET_REDO_BLKS
, LOG_FILE_SIZE_REDO_BLKS
, LOG_CHKPT_TIMEOUT_REDO_BLKS
, LOG_CHKPT_INTERVAL_REDO_BLKS
, FAST_START_IO_TARGET_REDO_BLKS
, TARGET_MTTR
, ESTIMATED_MTTR
, CKPT_BLOCK_WRITES
, OPTIMAL_LOGFILE_SIZE
, ESTD_CLUSTER_AVAILABLE_TIME
, WRITES_MTTR
, WRITES_LOGFILE_SIZE
, WRITES_LOG_CHECKPOINT_SETTINGS
, WRITES_OTHER_SETTINGS
, WRITES_AUTOTUNE
, WRITES_FULL_THREAD_CKPT
, CON_ID
FROM SYS.V_$INSTANCE_RECOVERY;
|
|
|