ttCkptConfigGet

This procedure returns the currently active settings of the configuration parameters.
It only helps to view the configuration parameters. To configure the parameters, see ttCkptConfig.

Required Privilege

This procedure requires no privilege to query the current values. It requires the ADMIN privilege to change the current values.

Related Views

This procedure has this related view.

SYS.V$CKPT_CONFIG

Syntax

ttCkptConfigGet(ckptFrequency, ckptLogVolume, ckptRate)

Parameters

ttCkptConfigGet has no parameters.

Result Set

ttCkptConfigGet returns the following results.

Column Type Description

ckptFrequency

TT_INTEGER NOT NULL

Currently active setting for checkpoint frequency in seconds.

ckptLogVolume

TT_INTEGER NOT NULL

Currently active setting for log volume between checkpoints in MB.

ckptRate

TT_INTEGER NOT NULL

Current rate at which TimesTen writes checkpoints to disk.

Examples

To view the current settings of the background checkpointer configuration parameters, use:

CALL ttCkptConfigGet;
< 600, 32, 0 >
1 row found.