You use the Caches tab to specify cache sizes and cache-related settings for block storage databases.
As you decide whether to select the “Cache memory locking” option, consider the following:
A cleared option (the default) denies priority usage of system RAM to the Essbase Server kernel.
You can select the option only if the input/output setting for Essbase is direct I/O. See Selecting an Access (I/O) Mode.
A selected option locks the memory used by the index, data file, and data caches into physical memory.
A selected option may improve performance because the system memory manager does not need to swap and reserve space for the memory used by the database caches.
If you select the option, you should leave at least one-third of the system RAM available for non-Essbase kernel use.
In the “Cache sizes” node, you specify the sizes of various buffers and, thereby, determine how much memory is allocated for the index, data file, and data caches. For default, minimum, and recommended values, see the Oracle Essbase Database Administrator's Guide and Checking Index and Data File Sizes.
Index cache setting
Data file cache—For holding compressed data (.pag) files (not used if Essbase is using buffered I/O)
Data cache setting—For holding uncompressed data blocks
The following boxes of the “Cache sizes” node display the amount of memory being used for the index, data file, and data caches. In all cases, if the database contains no data, the value is 0.
Index cache current value
Data file cache current value
Data cache current value
Changes to cache settings become effective when one of the following events occurs:
The database is started.
The RESETDB command (ESSCMD), which clears all data, is issued.
All data is cleared.
The Index page setting box displays the size of the index page (8 KB and unchangeable). If the database contains data, the “Index page current value” node displays the value that is displayed for the index page setting. If the database does not contain data, the box displays 0.
“Optimizing Essbase Caches” in the Oracle Essbase Database Administrator's Guide
“Understanding the Essbase Server Kernel” in the Oracle Essbase Database Administrator's Guide
alter database (MaxL) in the Oracle Essbase Technical Reference
query database (MaxL) in the Oracle Essbase Technical Reference
setdbstate (ESSCMD) in the Oracle Essbase Technical Reference
setdbstateitem (ESSCMD) in the Oracle Essbase Technical Reference
getperfstats (ESSCMD) in the Oracle Essbase Technical Reference