Library /sys$common/syshlp/SQL$HELP72.HLB  —  ALTER  DATABASE  Arguments  COMMIT_TO_JOURNAL_OPTIMIZATION
    Syntax options:

    COMMIT TO JOURNAL OPTIMIZATION | NO COMMIT TO JOURNAL
    OPTIMIZATION

    If you enable COMMIT TO JOURNAL OPTIMIZATION when you enable fast
    commit processing, Oracle Rdb does not write commit information
    to the database root file. This option enhances performance
    in database environments that are update-intensive. Because
    of the prerequisites for enabling the journal optimization
    option, general-use databases or databases that have many read-
    only transactions may not benefit from this feature. For more
    information, see the Oracle Rdb7 Guide to Database Performance
    and Tuning.

                                   NOTE

       If you specify COMMIT TO JOURNAL OPTIMIZATION, you must
       disable or defer snapshots.

       If you change snapshots to ENABLED IMMEDIATE, then you must
       specify NO COMMIT TO JOURNAL OPTIMIZATION.
Close Help