Query Application (Aggregate Storage)
Get information about the current state of the application.
This statement requires the application to be started. This statement is only applicable for applications using aggregate storage mode.
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:
| Output Columns | Description |
|---|---|
| Cache hit ratio | Ratio of the number of requests answered from aggregate storage cache as opposed to from the hard disk. |
| 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). |