v$instance_recovery
fast_start_mttr_target
[@more@]SQL> show parameter fast
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
fast_start_io_target integer 0
fast_start_mttr_target integer 300
fast_start_parallel_rollback string LOW
sql>select
t.RECOVERY_ESTIMATED_IOS REIO,
t.ACTUAL_REDO_BLKS ARB,
t.LOG_FILE_SIZE_REDO_BLKS TRB,
t.LOG_CHKPT_TIMEOUT_REDO_BLKS LCTRB,
t.LOG_CHKPT_INTERVAL_REDO_BLKS LCIRB,
t.TARGET_REDO_BLKS TMTTR,
t.ESTIMATED_MTTR EMTTR,
t.CKPT_BLOCK_WRITES CBW
from v$instance_recovery t
REIO ARB TRB LCTRB LCIRB TMTTR EMTTR CBW
---------- ---------- ---------- ---------- ---------- ---------- ---------- ----------
16207 257220 552960 483057 483057 294 37558787
当 t.ESTIMATED_MTTR 接近或者超过 fast_start_mttr_target 的时候，开始触发ckpt 进程。
到 oracle 10g , fast_start_mttr_target ＝ 0 ,自动调整
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/66233/viewspace-995405/ ，如需转载，请注明出处，否则将追究法律责任。
