GV$INSTANCE_RECOVERY definition in Oracle Database 11.2
GV$INSTANCE_RECOVERY
select
T.INST_ID, -- INST_ID NUMBER
to_number( -- RECOVERY_ESTIMATED_IOS NUMBER
decode(CUR_EST_RCV_READS, -1, NULL, CUR_EST_RCV_READS)),
to_number( -- ACTUAL_REDO_BLKS NUMBER
decode(ACTUAL_REDO_BLKS, -1, NULL, ACTUAL_REDO_BLKS)),
to_number( -- TARGET_REDO_BLKS NUMBER
decode(MIN_LAG, 0, NULL, MIN_LAG)),
to_number( -- LOG_FILE_SIZE_REDO_BLKS NUMBER
decode(LOGFILESZ, 0, NULL, LOGFILESZ)),
to_number( -- LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
decode(CT_LAG, 0, NULL, CT_LAG)),
to_number( -- LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
decode(CI_LAG, 0, NULL, CI_LAG)),
to_number( -- FAST_START_IO_TARGET_REDO_BLKS NUMBER
decode(ACTUAL_REDO_BLKS, 0, NULL, NULL)),
INUSE_NONRAC_MTTR_SEC+INUSE_RAC_MTTR_SEC,-- TARGET_MTTR NUMBER
to_number( -- ESTIMATED_MTTR NUMBER
decode(CUR_EST_IR_SEC, -1, CUR_EST_NONRAC_MTTR_SEC, CUR_EST_IR_SEC)),
( -- CKPT_BLOCK_WRITES NUMBER
select
ksusgstv - (
select
ksusgstv
from
X$KSUSGSTA
where
ksusdnam='physical writes non checkpoint' and inst_id=t.inst_id)
from
X$KSUSGSTA
where
ksusdnam = 'physical writes' and inst_id=t.inst_id),
( -- OPTIMAL_LOGFILE_SIZE NUMBER
select
logfile_size
from
x$kctlax
where
indx=0 and inst_id=t.inst_id),
to_number( -- ESTD_CLUSTER_AVAILABLE_TIME NUMBER
decode(CUR_EST_CA_SEC, -1, NULL, CUR_EST_CA_SEC)),
MTTR_WRITES, -- WRITES_MTTR NUMBER
LOGFILE_SIZE_WRITES, -- WRITES_LOGFILE_SIZE NUMBER
CKPT_SETTING_WRITES, -- WRITES_LOG_CHECKPOINT_SETTINGS NUMBER
OTHER_WRITES, -- WRITES_OTHER_SETTINGS NUMBER
AUTO_WRITES, -- WRITES_AUTOTUNE NUMBER
FULL_WRITES -- WRITES_FULL_THREAD_CKPT NUMBER
from
X$TARGETRBA T,
X$ESTIMATED_MTTR E,
X$KCTICW W
where
T.INST_ID=E.INST_ID AND T.INST_ID=W.INST_ID