LOG_CHECKPOINT_TIMEOUT
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.
| Property | Description |
|---|---|
| Parameter type | Integer |
| Default value | 1800 |
| 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. |
Specifying a value of 0 for the timeout disables time-based checkpoints. Hence, setting the value to 0 is not recommended unless FAST_START_MTTR_TARGET is set.
Note:
-
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
LOG_CHECKPOINT_INTERVALparameter or by the size specified for the smallest redo log. For information on which mechanism is controlling checkpointing behavior, query theV$INSTANCE_RECOVERYview.
See Also:
-
Oracle AI Database Performance Tuning Guide for information on disabling or removing this parameter when the
FAST_START_MTTR_TARGETparameter is set