DATACACHESIZE

This configuration setting defines the value for the data cache size for Essbase cubes. The data cache is a buffer in memory that holds data blocks. Essbase allocates this memory during data load, calculation, and retrieval operations, as needed.

This setting does not apply to aggregate storage cubes.

Syntax

DATACACHESIZE n

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

  • Minimum value: 3 megabytes (3M)

  • Maximum value: 2 gigabytes (2G)

  • Default value: 100 megabytes (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).

Description

DATACACHESIZE specifies, in bytes, kilobytes, megabytes, or gigabytes, the size of the data cache for cubes.

Example

DATACACHESIZE 90M

Sets the data cache size of databases to 90 megabytes.