View Commands in the SQL Command Cache

The cmdcache command invokes the ttSqlCmdCacheInfo built-in procedure to display the contents of the TimesTen SQL command cache.

If you run the cmdcache command without parameters, the full SQL command cache contents are displayed. Identical to the ttSqlCmdCacheInfo built-in procedure, you can provide a command ID to specify a specific command to be displayed.

In addition, the cmdcache command can filter the results so that only those commands that match a particular owner or query text are displayed.

The syntax for the cmdcache command is as follows:

cmdcache [[by {sqlcmdid | querytext | owner}] <query_substring>

If you provide the owner parameter, the results are filtered by the owner, identified by the <query_substring>, displayed within each returned command. If you provide the querytext parameter, the results are filtered so that all queries are displayed that contain the substring provided within the <query_substring>. If only the <query_substring> is provided, such as cmdcache <query_substring>, the command assumes to filter the query text by the <query_substring>. See cmdcache command.

 Command> cmdcache profile;
< 552126952, -1, 0, 1, 0, 0, 4784, SYS, select pn.profile# from sys.profname$ pn where pn.name = :profilename, 0, <NULL>, 0, 0, 0, 0, <NULL>, 0, 0, 0, 0 >
< 552131576, -1, 0, 1, 0, 0, 6088, SYS, select p.resource#, p.limit# from sys.profile$ p where p.type# = 0 and p.profile# = :profileid, 0, <NULL>, 0, 0, 0, 0, <NULL>, 0, 0, 0, 0 >
< 552110408, -1, 1, 1, 0, 0, 7160, SYS, select u.user#, u.password, u.identification, u.astatus, u.lcount, u.ltime, u.profile# from sys.user$ u where u.name = :name and u.type# = 1, 1, 2024-09-24 19:48:13.409000, 0, 0, 0, 0, <NULL>, 1304, 1304, 0, 0 >
3 rows found.