SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—640322-001
9-117
Considerations for QUERYCACHE
more information about the types of statements that are appropriate candidates for
query plan caching, see the SQL/MX Query Guide.
Column Name Data Type Description
CURRENT_SIZE INT Current size of the text and template cache.
MAX_CACHE_SIZE INT Maximum cache size in KB.
MAX_NUM_VICTIMS INT Maximum number of template cache entries
that can be displaced from the cache to
make room for a new entry. This number is
the current
QUERY_CACHE_MAX_VICTIMS CQD
setting.
NUM_ENTRIES INT Number of template cache entries.
NUM_PINNED INT Total number of pinned entries.
NUM_COMPILES INT Number of complete SQL compile requests
(excludes DESCRIBE and SHOWSHAPE
requests).
NUM_RECOMPILES INT Number of recompilations.
Recompilation refreshes a stale cache entry.
Schema changes can cause cached queries
to become stale.
NUM_RETRIES INT Number of successful compiles that succeed
with caching off but fail with caching on.
Report any occurrence to HP support.
NUM_CACHEABLE_
PARSING
INT Number of compiled queries that mxcmp has
processed after parsing and before binding
of the query and that satisfy the conditions
for caching.
NUM_CACHEABLE_
BINDING
INT Number of compiled queries that mxcmp has
processed after binding and before
transformation of the query and that satisfy
the conditions for caching.
NUM_CACHE_HITS_
PARSING
INT Number of queries that mxcmp has compiled
as cache hits after parsing.
NUM_CACHE_HITS_
BINDING
INT Number of queries that mxcmp has compiled
as cache hits after binding.
NUM_CACHEABLE_TOO_
LARGE
INT Number of cacheable queries compiled by
mxcmp that satisfy the conditions for caching
but have plans that are too large to fit in the
cache or have displaced too many cache
entries (value >
QUERY_CACHE_MAX_VICTIMS).
NUM_DISPLACED INT Number of entries displaced by template
cache entries (to make room for new entries
or displaced as a result of resizing of the
cache).