Query Application
The MaxL query application statement for block storage (BSO) applications helps you get the maximum cache size of an Essbase application. To issue this statement, the application must be started first, and you need at least Database Access permission for the application.
Keywords
You can query the application state information in the following ways using MaxL query application.
- query application APP-NAME get cache_size
-
Check the current maximum size setting to which the application cache may grow. The application cache grows dynamically until it reaches this limit. The application cache can help you manage memory usage for retrievals. For block storage cubes, the application cache is used for hybrid aggregation.
Example
alter system load application ASOSamp;
query application ASOSamp get cache_size;