select
  RECOVERY_ESTIMATED_IOS,                  -- RECOVERY_ESTIMATED_IOS NUMBER
  ACTUAL_REDO_BLKS,                        -- ACTUAL_REDO_BLKS NUMBER
  TARGET_REDO_BLKS,                        -- TARGET_REDO_BLKS NUMBER
  LOG_FILE_SIZE_REDO_BLKS,                 -- LOG_FILE_SIZE_REDO_BLKS NUMBER
  LOG_CHKPT_TIMEOUT_REDO_BLKS,             -- LOG_CHKPT_TIMEOUT_REDO_BLKS NUMBER
  LOG_CHKPT_INTERVAL_REDO_BLKS,            -- LOG_CHKPT_INTERVAL_REDO_BLKS NUMBER
  FAST_START_IO_TARGET_REDO_BLKS,          -- FAST_START_IO_TARGET_REDO_BLKS NUMBER
  TARGET_MTTR,                             -- TARGET_MTTR NUMBER
  ESTIMATED_MTTR,                          -- ESTIMATED_MTTR NUMBER
  CKPT_BLOCK_WRITES,                       -- CKPT_BLOCK_WRITES NUMBER
  OPTIMAL_LOGFILE_SIZE,                    -- OPTIMAL_LOGFILE_SIZE NUMBER
  ESTD_CLUSTER_AVAILABLE_TIME,             -- ESTD_CLUSTER_AVAILABLE_TIME NUMBER
  WRITES_MTTR,                             -- WRITES_MTTR NUMBER
  WRITES_LOGFILE_SIZE,                     -- WRITES_LOGFILE_SIZE NUMBER
  WRITES_LOG_CHECKPOINT_SETTINGS,          -- WRITES_LOG_CHECKPOINT_SETTINGS NUMBER
  WRITES_OTHER_SETTINGS,                   -- WRITES_OTHER_SETTINGS NUMBER
  WRITES_AUTOTUNE,                         -- WRITES_AUTOTUNE NUMBER
  WRITES_FULL_THREAD_CKPT                  -- WRITES_FULL_THREAD_CKPT NUMBER
from
  GV$INSTANCE_RECOVERY
where
  INST_ID = USERENV('Instance')