Sets the maximum number of minutes that the database server will run without doing a checkpoint.

Allowed values

Integer

Default

60

Scope

Can be set for the PUBLIC group only. DBA authority required. You must shut down and restart the database server for the change to take effect.

Remarks

This option is used with the recovery_time option to decide when checkpoints should be done.

See also

• Checkpoints and the checkpoint log
• recovery_time option [database]
• How the database server decides when to checkpoint