Sets the maximum length of time, in minutes, that the database
server takes to recover from system failure.
Allowed Values
Integer, in minutes
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 restart the
server for the change to take effect.
Remarks
Use this option with the CHECKPOINT_TIME option to decide when
checkpoints should be done.
A heuristic measures the recovery time based on the operations
since the last checkpoint. Thus, the recovery time is not exact.