CHECKPOINT_TIME Option

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

Allowed Values

Integer

Default

Scope

Option can be set at the database (PUBLIC) level only.

Requires the SET ANY SYSTEM OPTION system privilege to set this 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.