Applies only to aggregate storage databases. Returns detailed statistics for the outline paging cache.
GETOPGCACHESTATISTICS applicationname
This command returns information about the effectiveness of the outline paging cache, including information on the number of pages that Analytic Services finds in the cache and the number of pages that need to be read into the cache.
The following columns are the output of GETOPGCACHESTATISTICS:
Column Name | Contents |
---|---|
Total cache size |
Cache size in gigabytes and in bytes. |
Requested pages found in the cache |
Number of requested pages found in the cache. I/O was not necessary. |
Requested pages read into the cache |
Number of requested pages not found in the cache. I/O was necessary to load the pages into the cache. |
Clean pages forced from the cache |
Number of pages removed from the cache to create space for pages
loaded from the outline file (.otl file). |
Current clean buffer count |
Number of pages loaded into the cache and not modified. |
Current dirty buffer count |
Number of pages loaded into the cache and then modified. |
GETOPGCACHESTATISTICS Sample;
Returns the following information:
-------Application OPG Environment State------- Total cache size : 0 gigabytes 10487832 bytes Requested pages found in the cache : 4399 (87%) Requested pages read into the cache : 651 Clean pages forced from the cache : 0 Dirty pages forced from the cache : 0 Current clean buffer count : 651 Current dirty buffer count : 0
GETOPGDIMSTATISTICS
GETDBACTIVE
GETDBINFO
GETDBSTATE
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |