Cache Properties

Note:

Cache properties apply to block storage databases only.

The Caches tab displays cache sizes and cache locks in the following areas:

• Cache memory locking—Enables cache memory locking for databases for which you have Database Manager permissions

  Memory locking may improve database performance, because the system memory manager does not have to swap and reserve memory for Oracle Essbase caches. Memory locking changes become effective after the database is stopped and restarted.

• Index page setting (KB)—Size of the index page (8 KB and unchangeable)

• Index page current value (KB)—Value of the index page setting if the database contains data

• Cache Sizes—Sizes of various buffers that help 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.

• Index cache setting (KB)—Amount of memory, in kilobytes, to use for the index

• Index cache current value (KB)—Current amount of memory used for the index

• Data file cache setting (KB)—Amount of memory, in kilobytes, to hold compressed data (.pag) files. (Not applicable if the database is using buffered I/O.)

• Data file cache current value (KB)—Amount of memory used for the data file

• Data cache setting (KB)—Amount of memory, in kilobytes, used to hold uncompressed data blocks

• Data cache current value (KB)—Amount of memory used for the data cache