首页 > 应用开发 > IT综合 > Automatic Checkpoint Tuning

Automatic Checkpoint Tuning

原创 IT综合 作者:tsinglee 时间:2007-10-19 17:07:56 0 删除 编辑


In Oracle10g, fast_start_mttr_target behaves slightly differently. Specifying any non-zero value
will tell Oracle to automatically tune checkpointing by optimizing the frequency of dirty buffer
writes. The default is to enable automatic checkpoint tuning. The only way to turn this off is to
explicitly set the parameter to 0.

When Automatic Checkpoint Tuning has been disabled you can use the Redo Logfile Size Advisor to tune
an optimal size for the online redo logs based on checkpointing demands.


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量