1.187 LOG_CHECKPOINT_INTERVAL
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 |
|
Modifiable |
|
Modifiable in a PDB |
No |
Range of values |
|
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) forLOG_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 theV$INSTANCE_RECOVERY
view.
See Also:
-
Oracle Database Performance Tuning Guide for information on disabling or removing this parameter when the
FAST_START_MTTR_TARGET
parameter is set