Integer 

Dynamic. Scope = ALTER SYSTEM. 

Oracle8i: 900 seconds. Enterprise Edition: 1800 seconds. 

0 to unlimited 

Multiple instances can have different values. 

LOG_CHECKPOINT_TIMEOUT specifies that the incremental checkpoint is at the position where the last write to the redo log (sometimes called the "tail of the log") was integer seconds ago. This parameter also signifies that no buffer will remain dirty (in the cache) for more than integer seconds. The value is specified in 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.

See Also:

• Oracle8i Designing and Tuning for Performance for more information on setting this parameter.

• "FAST_START_IO_TARGET", "LOG_CHECKPOINT_TIMEOUT", and "V$INSTANCE_RECOVERY".