Essbase uses the aggregate storage cache to facilitate use of memory during data loads, aggregations, and retrievals. When an aggregate storage application is started, Essbase allocates a small area in memory as the aggregate storage cache for the application. As needed, Essbase increases the cache size incrementally until the maximum cache size specified for the application is reached or until the operating system denies additional allocations.
You can view the current aggregate cache size, and you can change the setting for maximum aggregate cache size. For information about managing the aggregate storage cache, see the Oracle Essbase Database Administrator's Guide.
To view and change the maximum size of an aggregate storage cache:
From Enterprise View or a custom view, select an application.
Right-click, and select Edit properties.
In the Application Properties window, select the General tab.
Next to the Pending cache size limit node, enter a value, in megabytes, for the size of the cache.
Click Apply.
The cache setting becomes effective after the application is restarted.
“Managing the Aggregate Storage Cache” in the Oracle Essbase Database Administrator's Guide
alter application (MaxL) in the Oracle Essbase Technical Reference
query application (MaxL) in the Oracle Essbase Technical Reference