ITPub博客

首页 > Linux操作系统 > Linux操作系统 > LOG_CHECKPOINT_TIMEOUT(原)

LOG_CHECKPOINT_TIMEOUT(原)

原创 Linux操作系统 作者:tochar 时间:2007-07-25 00:00:00 0 删除 编辑

LOG_CHECKPOINT_TIMEOUT

Parameter type

Integer

Default value

1800

Parameter class

Dynamic: ALTER SYSTEM

Range of values

0 to unlimited

Real Application Clusters

Multiple instances can have different values.

LOG_CHECKPOINT_TIMEOUT specifies (in seconds) the amount of time that has passed since the incremental checkpoint at the position where the last write to the redo log (sometimes called the tail of the log) occurred. This parameter also signifies that no buffer will remain dirty (in the cache) for more than integer seconds.

Specifying a value of 0 for the timeout disables time-based checkpoints. Hence, setting the value to 0 is not recommended.


Notes:
  • A checkpoint scheduled to occur because of this parameter is delayed until the completion of the previous checkpoint if the previous checkpoint has not yet completed.
  • Recovery I/O can also be limited by setting the FAST_START_IO_TARGET or LOG_CHECKPOINT_INTERVAL parameter or by the size specified for the smallest redo log. For information on which mechanism is controlling checkpointing behavior, query the V$INSTANCE_RECOVERY view.


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9078678/viewspace-45097/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-12-11

  • 博文量
    118
  • 访问量
    788960