Database Cache Settings

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

Table 164. Database Cache Settings

Setting

Topic

Location

Index cache size

Sizing the Index Cache

  • Administration Services: Database Properties window, Caches tab

  • MaxL:

    alter database appname.dbname set index_cache_size n

  • ESSCMD: SETDBSTATEITEM 12

Data file cache size

Sizing the Data File Cache

  • Administration Services: Database Properties window, Caches tab

  • MaxL:

    alter database appname.dbname set data_file_cache_size n

  • ESSCMD: SETDBSTATEITEM 27

Data cache size

Sizing the Data Cache

  • Administration Services: Database Properties window, Caches tab

  • MaxL:

    alter database appname.dbname set data_cache_size n

  • ESSCMD: SETDBSTATEITEM 5

Index page size

Fixed size

N/A

Cache memory locking

Deciding Whether to Use Cache Memory Locking

  • Administration Services: Database Properties window, Caches tab

  • MaxL:

    alter database appname.dbname enable cache_pinning

  • ESSCMD: SETDBSTATEITEM 26

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