p29.sql

oracal的入门知识

select RECOVERY_ESTIMATED_IOS REIO,
        ACTUAL_REDO_BLKS ARB,
        TARGET_REDO_BLKS TRB,
        LOG_FILE_SIZE_REDO_BLKS LFSRB,
        LOG_CHKPT_TIMEOUT_REDO_BLKS LCTRB,
        LOG_CHKPT_INTERVAL_REDO_BLKS LCIRB,
        FAST_START_IO_TARGET_REDO_BLKS FSIOTRB,
        TARGET_MTTR TMTTR,
        ESTIMATED_MTTR EMTTR,
        CKPT_BLOCK_WRITES CBW
 from v$instance_recovery;