Oracle 参数 LOG_CHECKPOINT_INTERVAL 官方解释,作用,如何配置最优化建议

本站中文解释

LOG_CHECKPOINT_INTERVAL参数用于指定 Oracle 用于检查点的间隔。当内存加载的redo写入日志时,默认情况下,检查点将导致全局检查点(GCP)发生,GCP会把redo写入到日志文件中,以释放内存空间,但会拖慢系统性能。

LOG_CHECKPOINT_INTERVAL参数用于指定Oracle每log_checkpoint_interval相应的记录数(每完成log_checkpoint_interval条记录)就检查一次,提高检查点效率,充分利用检查点性能。

正确设置:需要将LOG_CHECKPOINT_INTERVAL参数设置的大一些,让Oracle有更多的redo写入内存,然后正确的将其写入日志文件中,可以有效的提高系统性能。

官方英文解释

LOG_CHECKPOINT_INTERVAL specifies the frequency of checkpoints in terms of the number of redo log file blocks that can exist between an incremental checkpoint and the last block written to the redo log. This number refers to physical operating system blocks, not database blocks.
Property Description

Parameter type

Integer

Default value

0

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

0 to 231 – 1

Basic

No

Oracle RAC

Multiple instances can have different values.

Regardless of this value, a checkpoint always occurs when switching from one online redo log file to another. Therefore, if the value exceeds the actual redo log file size, checkpoints occur only when switching logs. Checkpoint frequency is one of the factors that influence the time required for the database to recover from an unexpected failure.

Note:

  • Specifying a value of 0 (zero) for LOG_CHECKPOINT_INTERVAL has the same effect as setting the parameter to infinity and causes the parameter to be ignored. Only nonzero values of this parameter are considered meaningful.

  • Recovery I/O can also be limited by setting the LOG_CHECKPOINT_TIMEOUT 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.

See Also:

  • “LOG_CHECKPOINT_TIMEOUT”

  • “V$INSTANCE_RECOVERY”

  • Oracle Database
    Performance Tuning Guide
    for information on disabling or removing this parameter when the FAST_START_MTTR_TARGET parameter is set


数据运维技术 » Oracle 参数 LOG_CHECKPOINT_INTERVAL 官方解释,作用,如何配置最优化建议