CHECKPOINT_TIME option

Function

Set the maximum length of time, in minutes, that the database server runs without doing a checkpoint.

Allowed values

Integer

Default

60

Scope

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

Description

This option is used with the “RECOVERY_TIME option” to decide when checkpoints should be done.