Syntax options:

    PRESTARTED TRANSACTIONS ARE ON | PRESTARTED TRANSACTIONS ARE OFF

    Specifies whether Oracle Rdb enables or disables prestarted
    transactions.

    Use the PRESTARTED TRANSACTIONS ARE OFF clause only if your
    application uses a server process that is attached to the
    database for long periods of time and causes the snapshot file
    to grow excessively. If you use the PRESTARTED TRANSACTIONS
    ARE OFF clause, Oracle Rdb uses additional I/O because each SET
    TRANSACTION statement must reserve a transaction sequence number
    (TSN).

    For most applications, Oracle Rdb recommends that you enable
    prestarted transactions. The default is PRESTARTED TRANSACTIONS
    ARE ON. If you use the PRESTARTED TRANSACTIONS ARE ON clause or
    do not specify the PRESTARTED TRANSACTIONS clause, the COMMIT
    or ROLLBACK statement for the previous read/write transaction
    automatically reserves the TSN for the next transaction and
    reduces I/O.

    You can define the RDMS$BIND_PRESTART_TXN logical name to define
    the default setting for prestarted transactions outside of an
    application. The PRESTARTED TRANSACTION clause overrides this
    logical name. For more information, see the Oracle Rdb7 Guide to
    Database Performance and Tuning. See also the ALTER and CREATE
    DATABASE clause PRESTARTED TRANSACTIONS ARE ENABLED for more
    details.