1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. INDEXCACHESIZE

INDEXCACHESIZE

The index cache is a buffer in memory that holds index pages for block storage databases. Essbase allocates the memory upon startup of the cube. The INDEXCACHESIZE configuration setting enables you to define the size of the index cache.

The value of the index cache size can be expressed in bytes, kilobytes, megabytes, or gigabytes. Terabytes must be expressed in gigabytes.

INDEXCACHESIZE configuration applies only to block storage (BSO) databases, and does not apply to aggregate storage (ASO) databases.

Syntax

INDEXCACHESIZE n

n—An integer value expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G):

  • Minimum value: 1 megabytes (1M)

  • Maximum value: 256TB

  • Default value: 100M

If a value is given without a B, K, M, or G qualifier, it is assumed the value is in bytes.

The qualifier can be in upper or lowercase and can be entered adjacent to the value (10M) or separated by a space (10 M).

Example

INDEXCACHESIZE 200M

Sets the index cache size of cubes to 200 megabytes.