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

home |  up