SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Reference Manual—540440-003
9-115
Examples of QUERYCACHEENTRIES
100 MANAGER
200 PRODUCTION SUPV
250 ASSEMBLER
.
.
.
--- 10 row(s) selected.
>SELECT * FROM TABLE (QUERYCACHEENTRIES ());
ROW_ID PLAN_ID TEXT ENTRY_SIZE
------ ------------------ -------------------------- ----------
0 211894097543468116 select * from employee; 32410
1 211894097552547493 select * from job; 24968
2 211894097548497817 select * from dept; 29730
NUM_HITS PHASE OPTIMIZATION_LEVEL CATALOG_NAME SCHEMA_NAME
-------- ---------- ---------------------- ------------ -----------
1 BINDING 3 SAMDBCAT PERSNL
0 BINDING 3 SAMDBCAT PERSNL
0 BINDING 3 SAMDBCAT PERSNL
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.