Specifies the maximum amount of memory allocated for the dynamic calculator cache.
This setting does not apply to aggregate storage databases.
DYNCALCCACHEMAXSIZE [appname [dbname]] n
appname—If you supply an application name, the setting applies to all databases within the application. If you do not supply an application name, the setting applies to all applications and databases on the server.
dbname—If you supply a database name, the setting applies only to the database. If you do not also provide an application name, the setting applies to all applications and databases on the server.
n—An integer expressed in bytes (B), kilobytes (K), megabytes (M), or gigabytes (G)
Minimum value: 0 megabytes (0 M). If the value is 0, Essbase does not use dynamic calculator cache.
Default value: 20 megabytes (20M, which is 20,971,520 bytes)
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).
This setting specifies, in bytes, kilobytes, megabytes, or gigabytes, the maximum amount of memory that Essbase can allocate for the dynamic calculator cache for each database. The specified value takes effect for all databases that are opened after the server is started.
The dynamic calculator cache is a memory buffer that holds data blocks that are expanded to include dynamically calculated members. Essbase allocates memory in the dynamic calculator cache to store these blocks during retrievals or calculations that involve dynamically calculated members.
Using dynamic calculator cache may improve retrieval performance by reducing the number of calls to the operating system to do memory allocations.
When the DYNCALCCACHEMAXSIZE setting is not equal to 0, you should also consider the following settings that affect how Essbase uses dynamic calculator cache:
Use DYNCALCCACHEWAITFORBLK and DYNCALCCACHEONLY to set or change how Essbase handles the situation when it has reached the maximum dynamic calculator cache size and needs more memory in the dynamic calculator cache to store dynamically calculated blocks.
See the Oracle Essbase Database Administrator's Guide for more information about Dynamic Calculator Cache and the related configuration file settings.
DYNCALCCACHEMAXSIZE 30M
Sets 30 megabytes as the maximum size for the dynamic calculator cache.
Oracle Essbase Database Administrator's Guide