GETOPGCACHESTATISTICS

Applies only to aggregate storage databases. Returns detailed statistics for the outline paging cache.

Syntax

GETOPGCACHESTATISTICS applicationname

Description

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.

Example

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

See Also

GETOPGDIMSTATISTICS
GETDBACTIVE
GETDBINFO
GETDBSTATE

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