Syntax option:

    TRANSACTION INTERVAL IS number-txns

    The TRANSACTION INTERVAL IS clause specifies the size of the
    transaction sequence number (TSN) range where number-txns equals
    the number of TSNs. Oracle Rdb uses transaction sequence numbers
    to ensure database integrity. When you specify NO COMMIT TO
    JOURNAL OPTIMIZATION, Oracle Rdb assigns TSNs to users one at
    a time. When you enable the journal optimization option, Oracle
    Rdb preassigns a range of TSNs to each user. Assigning a range
    of TSNs means that commit information need not be written to
    the database root for each transaction. Oracle Rdb writes all
    transaction information to the .aij file except for each user's
    allocated TSN range, which it writes to the root file.

    The transaction interval value (the TSN range) must be a number
    between 8 and 1024. The default value is 256.

    In general, if your database has few users or if all user
    sessions are long, select a large transaction interval. If your
    database has many users or if user sessions are short, select a
    smaller transaction interval.