Miscellaneous Database Settings

Table 167 describes miscellaneous database settings and lists the location of the settings in Administration Services, MaxL, and ESSCMD:

Table 167. Miscellaneous Database Settings

Setting

Topic

Location

Retrieval buffer size

Setting the Retrieval Buffer Size

  • Administration Services: Database Properties window, General tab

  • MaxL:

    alter database appname.dbname set retrieve_buffer_size n

  • ESSCMD SETDBSTATEITEM 16

Retrieval sort buffer size

Setting the Retrieval Sort Buffer Size

  • Administration Services: Database Properties window, General tab

  • MaxL:

    alter database appname.dbname set retrieve_sort_buffer_size n

  • ESSCMD: SETDBSTATEITEM 17

Data compression

Data Compression

  • Administration Services: Database Properties window, Storage tab

  • MaxL:

    alter database appname.dbname enable compression

    and

    alter database appname.dbname set compression type

  • ESSCMD:

    SETDBSTATEITEM 14

    SETDBSTATEITEM 15

Maximum memory for trigger definitions

Understanding Triggers Definitions

MaxL:

create or replace trigger, alter trigger display trigger, and drop trigger

See “Setting Database Properties” in Oracle Essbase Administration Services Online Help.