Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  CHECKPOINT TIMED for fast commit
    Assigns a value to the checkpoint interval specifying the number
    of seconds that can pass before updated pages are written. When
    the specified number of seconds elapsed, Oracle Rdb executes the
    checkpoint steps.

    For example, if you specify TIMED EVERY 100 SECONDS, each process
    checkpoints after at least 100 seconds have passed since its last
    checkpoint.

    You can set both a checkpoint based on time and a checkpoint
    based on .aij file growth; Oracle Rdb performs a checkpoint
    operation at whichever checkpoint it reaches first.

    The following statement enables fast commit processing and
    specifies checkpoint intervals of 512 blocks and 12 seconds:

    SQL> ALTER DATABASE FILENAME test1
    cont> JOURNAL IS ENABLED
    cont>    (FAST COMMIT ENABLED
    cont>       (CHECKPOINT INTERVAL IS 512 BLOCKS,
    cont>        CHECKPOINT TIMED EVERY 12 SECONDS)
    cont>    );
Close Help