Initialization Parameters, 89 of 188

LOG_CHECKPOINT_INTERVAL

Parameter type:
Integer

Parameter class:
Dynamic. Scope = ALTER SYSTEM.

Default value:
Operating system dependent

Range of values:
Unlimited

Oracle Parallel Server:
Multiple instances can have different values.

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.
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.

Notes:

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 FAST_START_IO_TARGET or 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:

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

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

Parameter type:	Integer
Parameter class:	Dynamic. Scope = `ALTER` `SYSTEM.`
Default value:	Operating system dependent
Range of values:	Unlimited
Oracle Parallel Server:	Multiple instances can have different values.
`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. 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.
Notes: 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 `FAST_START_IO_TARGET` or `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: Oracle8i Designing and Tuning for Performance for more information on setting this parameter. "FAST_START_IO_TARGET", "LOG_CHECKPOINT_TIMEOUT", and "V$INSTANCE_RECOVERY".