Configuring or Turning Off Background Checkpointing

You can configure TimesTen to checkpoint either at a specific timed frequency or when the transaction log files contain a certain amount of data.

To configure checkpointing in TimesTen, do the following:

Configure the CkptFrequency and CkptLogVolume connection attributes as follows:

• The CkptFrequency connection attribute controls how often, in seconds, that TimesTen performs a background checkpoint. The default is 600 seconds. Set the CkptFrequency connection attribute to 0 if you want to control background checkpointing with the CkptLogVolume connection attribute.

• The CkptLogVolume connection attribute controls how much data, in megabytes, that collects in the transaction log file between background checkpoints. By increasing this amount, you can delay the frequency of the checkpoint. The default is 0. Set the CkptFrequency connection attribute to 0 if you want to control background checkpointing with the CkptLogVolume connection attribute.

In most cases, it is recommended to use CkptLogVolume over CkptFrequency, since CkptFrequency does not take into account the rate of database transactions. If both CkptFrequency and CkptLogVolume attributes are set with a value greater than 0, then a checkpoint is performed when either of the two conditions becomes true.

Alternatively, you can configure background checkpointing or turn it off by calling the ttCkptConfig built-in procedure. The values set by ttCkptConfig take precedence over those set with the connection attributes.

Note:

For information on default values and usage, see CkptFrequency, CkptLogVolume, and ttCkptConfig in the Oracle TimesTen In-Memory Database Reference.