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

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—523725-004
9-117
Examples of QUERYCACHEENTRIES
NUM_PARAMS PARAM_TYPES PLAN_LENGTH IS_PINNED COMPILATION_TIME
---------- ----------- ----------- --------- -----------------
0 31752 OFF 334
0 24504 OFF 54
0 29144 OFF 96
AVERAGE_HIT_TIME SHAPE ISOLATION_LEVEL ACCESS_MODE AUTO_COMMIT
---------------- ------- --------------- ------------ -----------
41 READ COMMITTED READ/WRITE ON
0 READ COMMITTED READ/WRITE ON
0 READ COMMITTED READ/WRITE ON
ROLLBACK_MODE
--------------
NOT SPECIFIED
NOT SPECIFIED
NOT SPECIFIED
•
Display selected columns of the QUERYCACHEENTRIES table using the same
cached queries:
>>SELECT PLAN_ID, NUM_HITS, IS_PINNED FROM TABLE
(QUERYCACHEENTRIES ());
PLAN_ID NUM_HITS IS_PINNED
------------------- ---------- ---------
211894097543468116 1 OFF
211894097552547493 0 OFF
211894097548497817 0 OFF
--- 3 row(s) selected.