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.

Output Columns

The following MaxL statement:

query application sample get opg_cache statistics;

returns the following information:

Column Name Contents
total_cache_size_gigabytes The size of the outline paging cache, in gigabytes.
total_cache_size_bytes The size of the outline paging cache, in bytes.
requested_pages_found Number of page hits. For these requests, no I/O was necessary because the page was found in the cache.
requested_pages_not_found Number of page misses. For these requests, I/O was necessary to load the page into the cache.
clean_pages_forced_out The number of pages removed from the cache to make room for pages that needed to be loaded from the .opg file.
current_clean_buffer_count The number of pages loaded into the cache that have not been modified.
current_dirty_buffer_count The number of pages that were loaded into the cache and subsequently modified.

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 aggregate storage cache grows dynamically until it reaches this limit. To change the currently set limit, use the following statement: alter application APP-NAME set cache_size SIZE-STRING;

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. The aggregate storage cache grows dynamically up to the limit you specify. 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. You can set the maximum size using alter application APP-NAME set cache_size SIZE-STRING. This setting takes effect after you restart the application. To check the currently set limit, use the following MaxL statement: query application APP-NAME get cache_size;
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).

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com