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.