Query Application (Aggregate Storage)

The MaxL query application statement for ASO mode helps you get information about the current state of an Essbase aggregate storage application.

This statement is only applicable for aggregate storage applications.

This statement requires the application to be started.

Syntax

Example

The following MaxL statement:

query application sample get cache_size;

returns the maximum size (in kilobytes) to which the aggregate storage cache may grow.

The following MaxL statement:

query application asoapp list aggregate_storage storage_info;

returns the following information:

Table 3-12 Query Application List Aggregate Storage Storage_Info MaxL Output Columns

Output Columns	Description
`Cache hit ratio`	Ratio of the number of requests answered from aggregate storage cache as opposed to from the hard disk. Note: This statistic may not be accurate when parallel data load or parallel calculation operations are in use.
`Current cache size (KB)`	The current size of the aggregate storage cache. See description for `current cache size limit (KB)`.
`Current cache size limit (KB)`	The maximum size (in kilobytes) to which the aggregate storage cache may grow.
`Page reads since last startup`	Number of data blocks (pages) read from disk since the last time the application was started.
`Page writes since last startup`	Number of data blocks (pages) written to disk since the last time the application was started.
`Page size (KB)`	Size of the data block (page) in kilobytes.
`Disk space allocated for data (KB)`	Total space used by all disk files in the `default` tablespace.
`Disk space used by data (KB)`	Total space actually in use within the disk files in the `default` tablespace (some space within files may be free).
`Temporary disk space allocated (KB)`	Total space used by all disk files in the `temp` tablespace.
`Temporary disk space used (KB)`	Total space actually in use within the disk files in the `temp` tablespace (some space within files may be free).