Database Transaction Control Settings

Table 166 describes database transaction control settings and lists the location of the settings in Administration Services, MaxL, and ESSCMD:

Table 166. Database Transaction Control Settings

Setting

Topic

Location

Isolation level

Understanding Isolation Levels

  • Administration Services: Database Properties window, Transactions tab

  • MaxL:

    alter database appname.dbname enable committed_mode

  • ESSCMD: SETDBSTATEITEM 18

Commit Blocks

Understanding Isolation Levels

  • Administration Services: Database Properties window, Transactions tab

  • MaxL:

    alter database appname.dbname enable committed_mode

    and

    alter database appname.dbname set implicit_commit after n blocks

  • ESSCMD: SETDBSTATEITEM 21

Commit Rows

Understanding Isolation Levels

  • Administration Services: Database Properties window, Transactions tab

  • MaxL:

    alter database appname.dbname enable committed_mode

    and

    alter database appname.dbname set implicit_commit after n rows

  • ESSCMD: SETDBSTATEITEM 22

Wait for write access to locked data block

Understanding Isolation Levels

  • Administration Services: Database Properties window, Transactions tab

  • MaxL:

    alter database appname.dbname set lock_timeout

  • ESSCMD: SETDBSTATEITEM 20

Pre-image access

Understanding Isolation Levels

  • Administration Services: Database Properties window, Transactions tab

  • MaxL:

    alter database appname.dbname enable pre_image_access

  • ESSCMD: SETDBSTATEITEM 19

See “Setting Data Integrity Options” in Oracle Essbase Administration Services Online Help.