Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  CHECKPOINT EVERY n TRANSACTIONS
    A FAST COMMIT option which allows the checkpoint to be generated
    after a set number of transactions.

    See the following example.

    SQL> alter database
    cont>     filename db$:scratch
    cont>
    cont>     journal is enabled
    cont>         (fast commit is enabled
    cont>             (checkpoint every 20 transactions,
    cont>              checkpoint timed every 20 seconds
    cont>             )
    cont>         )
    cont>     add journal rdb$journal
    cont>         filename db$:scratch_aij
    cont> ;
    %RDMS-W-DOFULLBCK, full database backup should be done to ensure future recovery
Close Help