SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-110
Considerations for QUERYCACHE
MAX_NUM_VICTIMS INT Maximum number of plans that can be
removed from the cache to make room for a
new entry.
NUM_ENTRIES INT Total number of entries in the cache.
NUM_PINNED INT Total number of pinned entries.
NUM_COMPILES INT Total number of complete compile requests
(excludes DESCRIBE and SHOWSHAPE
commands).
NUM_RECOMPILES INT Total number of recompilations. A
recompilation of a cached plan occurs when
it references a table that either has been
re-created or altered.
NUM_RETRIES INT Number of successful compiles that initially
fail with caching on and that succeed with
caching off.
NUM_CACHEABLE_
PARSING
INT Total number of SQL statements that mxcmp
has processed after parsing and before
binding of the query and that satisfy the
conditions for cacheability.
NUM_CACHEABLE_
BINDING
INT Total number of SQL statements that mxcmp
has processed after binding and before
transformation of the query and that satisfy
the conditions for cacheability.
NUM_CACHE_HITS_
PARSING
INT Total number of SQL statements that mxcmp
has processed after their parsing and before
their binding and that have produced hits.
NUM_CACHE_HITS_
BINDING
INT Total number of SQL statements that mxcmp
has processed after their binding and before
their transformation and that have produced
hits.
NUM_PIN_HITS_PARSING INT Total number of hits on pinned entries. The
hits occurred after parsing and before
binding.
NUM_PIN_HITS_BINDING INT Total number of hits on pinned entries. The
hits occurred after binding and before
transformation.
NUM_CACHEABLE_TOO_
LARGE
INT Number of SQL statements processed by
mxcmp that satisfy the conditions for
cacheability but whose plans are too large to
fit in the cache.
Column Name Data Type Description