Query Application (Aggregate Storage)
The MaxL query application statement for ASO helps you get information about the current state of an Essbase aggregate storage application.
Click here for block storage version
This statement is only applicable for aggregate storage applications.
This statement requires the application to be started.
Example
The following MaxL statement:
query application ASOSamp get cache_size;
returns the maximum size (in kilobytes) to which the aggregate storage cache may grow.
The following MaxL statement:
query application ASOSamp 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).
|