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)),
ACTUAL_REDO_BLKS,        -- ACTUAL_REDO_BLKS NUMBER
to_number                -- TARGET_REDO_BLKS NUMBER
  (decode (MIN_LAG, -1, NULL, MIN_LAG)),
to_number                -- LOG_FILE_SIZE_REDO_BLKS NUMBER
  (decode (LOGFILESZ, -1, NULL, LOGFILESZ)),
to_number                -- LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
  (decode (CT_LAG, -1, NULL, CT_LAG)),
to_number                -- LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
  (decode (CI_LAG, -1, NULL, CI_LAG)),
to_number                -- FAST_START_IO_TARGET_REDO_BLKS NUMBER
  (decode (ACTUAL_REDO_BLKS, 0, NULL, NULL)),
INUSE_EST_MTTR_SEC,      -- TARGET_MTTR NUMBER
CUR_EST_MTTR_SEC,        -- ESTIMATED_MTTR 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) 
from
X$TARGETRBA T,
X$ESTIMATED_MTTR E 
where
T.INST_ID=E.INST_ID
home |  up  |  mailbox