Run-time monitoring interface for page, query and object caches.
Get the names of active caches of a particular type:
CtsComponents::StringSeq getNames ( in long type );
The available cache types are:
0 - to obtain names of caches of all types |
PAGE_CACHE |
QUERY_CACHE |
OBJECT_CACHE. |
Retrieve run-time cache statistics. For each key in
keys
, a corresponding value is returned in the
result sequence.
CtsComponents::DoubleSeq getStatistics ( in long type, in string name, in CtsComponents::ShortSeq keys );
The following keys are available:
Key | Value |
---|---|
CACHE_ENTRY_COUNT | Number of entries in cache |
CACHE_HIT_RATIO | CACHE_HITS / (CACHE_MISSES + CACHE_TIMEOUTS) |
CACHE_HITS | Number of requests that found a valid matching entry |
CACHE_MISSES | Number of requests that did not find a matching entry |
CACHE_TIMEOUTS | Number of requests that found a timed-out entry |
CURRENT_CACHE_SIZE | Current cache size in bytes |
MAXIMUM_CACHE_SIZE | Maximum cache size in bytes (0 = no maximum) |
AVERAGE_ENTRY_SIZE | Average entry size in bytes |
MINIMUM_ENTRY_SIZE | Minimum entry size in bytes |
MAXIMUM_ENTRY_SIZE | Maximum entry size in bytes |
The available cache types are:
0 - to specify a named cache without regard for its type |
PAGE_CACHE |
QUERY_CACHE |
OBJECT_CACHE. |