Database Properties Window—Caches Tab

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:

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.

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.

Changes to cache settings become effective when one of the following events occurs:

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.

Related Information

Related Commands