[Home] [Help] [Dependency Information]
Object Name: | WRH$_INSTANCE_RECOVERY |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRH$_INSTANCE_RECOVERY_PK | NORMAL | UNIQUE | SYSAUX |
DBID
SNAP_ID INSTANCE_NUMBER CON_DBID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
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_DBID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, 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_DBID
FROM SYS.WRH$_INSTANCE_RECOVERY;
SYS.WRH$_INSTANCE_RECOVERY does not reference any database object
SYS.WRH$_INSTANCE_RECOVERY is referenced by following:
|
|
|