SQL/MX 3.2.1 Query Guide (H06.26+, J06.15+)

Query Plan Caching
HP NonStop SQL/MX Release 3.2.1 Query Guide—663851-003
6-12
QUERYCACHEENTRIES Function
PARAM_TYPES CHAR(1024) Comma-separated list of the types
of constants that were changed into
parameters. Blank if none.
PLAN_LENGTH INT UNSIGNED Size in bytes of the compiled plan
associated with this query.
IS_PINNED CHAR(6) Indicates whether the entry is
pinned. Can be ON or OFF.
COMPILATION_TIME INT UNSIGNED Time in milliseconds it took to
compile the query associated with
this entry.
AVERAGE_HIT_TIME INT UNSIGNED Time in milliseconds it took on
average to process a query as a
cache hit against this entry.
SHAPE CHAR (1024) Required CONTROL QUERY
SHAPE of the query associated with
this entry. Blank if no required
shape.
ISOLATION_LEVEL CHAR(20) Transaction isolation level
associated with the query. Can be
READ_UNCOMMITTED,
READ_COMMITTED,
REPEATABLE_READ,
SERIALIZABLE, NOT_SPECIFIED.
ACCESS_MODE CHAR(20) Transaction access mode value
associated with the query. Can be
READ_ONLY, READ_WRITE, or
NOT_SPECIFIED.
AUTO_COMMIT CHAR(15) Transaction auto-commit value
associated with the query. Can be
ON, OFF, or NOT_SPECIFIED.
ROLLBACK_MODE CHAR(15) Transaction rollback mode value
associated with the query. Can be
WAITED, NOWAITED, or
NOT_SPECIFIED.
Column Name Data Type Description
TP663851.fm Page 12 Wednesday, January 30, 2013 5:37 PM