9i 10g 检查点的增强

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博客 ” ，链接：http://blog.itpub.net/66233/viewspace-995405/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/66233/viewspace-995405/