V$INSTANCE_RECOVERY

Columns
   ___________________________
 
   LOG_CHKPT_INTERVAL_REDO_BLKS
   FAST_START_IO_TARGET_REDO_BLKS
   LOG_CHKPT_TIMEOUT_REDO_BLKS
   LOG_FILE_SIZE_REDO_BLKS
   TARGET_REDO_BLKS
   ACTUAL_REDO_BLKS
   RECOVERY_ESTIMATED_IOS

Related Commands: