CHECKPOINT_TIME
Option
Set the maximum length of time, in minutes, that the database server runs without doing a checkpoint.
Allowed Values
Integer
Default
60
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.