DYNCALCCACHEMAXSIZE

Specifies the maximum amount of memory allocated for the dynamic calculator cache.

This setting does not apply to aggregate storage databases.

Syntax

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, Analytic Services 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).

Description

This setting specifies, in bytes, kilobytes, megabytes, or gigabytes, the maximum amount of memory that Analytic Services 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. Analytic Services 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 Analytic Services uses dynamic calculator cache:

Notes

Example

DYNCALCCACHEMAXSIZE 30M
causes Analytic Services to set 30 megabytes as the maximum size for the dynamic calculator cache.

See Also

DYNCALCCACHEONLY
DYNCALCCACHEWAITFORBLK
DYNCALCCACHEBLKTIMEOUT
DYNCALCCACHEBLKRELEASE
DYNCALCCACHECOMPRBLKBUFSIZE
Database Administrator's Guide