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 may require additional I/O as 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 use ALTER DATABASE . . . PRESTARTED TRANSACTIONS clause
    to establish a default setting for all applications using the
    database. You can also 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 and database setting. For more
    information, see the Oracle Rdb7 Guide to Database Performance
    and Tuning.