GV$INSTANCE_RECOVERY

select
INST_ID,                 -- INST_ID NUMBER
CUR_EST_RCV_READS,       -- RECOVERY_ESTIMATED_IOS NUMBER
ACTUAL_REDO_BLKS,        -- ACTUAL_REDO_BLKS NUMBER
MIN_LAG,                 -- TARGET_REDO_BLKS NUMBER
LOGFILESZ,               -- LOG_FILE_SIZE_REDO_BLKS NUMBER
CT_LAG,                  -- LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
CI_LAG,                  -- LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
FS_LAG                   -- FAST_START_IO_TARGET_REDO_BLKS NUMBER
from
X$TARGETRBA
home |  up  |  mailbox