cmdcache

Syntax

cmdcache [[by {sqlcmdid |querytext|owner}] query_subsstring]

Description

Displays the contents of the TimesTen SQL command cache.

Specify the sqlcmdid, querytext or owner column and query substring to search for a specific portion of a SQL query. If no column is specified, searches the querytext column.

If passthrough is enabled, the command ID is not passed through to the Oracle database.

Examples

Command> cmdcache;
< 147347040, -1, 1, 1, 0, 0, 8336, ADMIN, call ttsqlcmdcacheinfo(), 1, 2024-08-29 03:08:39.370000, 0, 0, 0, 0, <NULL>, 0, 0, 0, 0 >
< 147586432, -1, 2, 2, 0, 1, 3616, SYS, call ttCkptOneElement( , , 'ttCkptLoadPLSQL');, 0, 2024-08-29 03:08:37.465000, 0, 0, 0, 0, <NULL>, 24, 24, 0, 0 >
< 147393976, -1, 0, 1, 0, 0, 5472, SYS, update sys.user$ u set u.lcount = u.lcount + 1 where u.user# = :userid, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 147388856, -1, 0, 1, 0, 0, 5760, SYS, update sys.user$ u set u.lcount = 0, u.astatus = :astatus where u.user# = :userid, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 147405768, -1, 0, 1, 0, 0, 5696, SYS, select u.password, u.password_date from sys.user_history$ u where u.user# = :userid order by u.password_date desc, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 143321728, -1, 0, 1, 0, 0, 5088, SYS, select pn.profile# from sys.profname$ pn where pn.name = :profilename, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 147383224, -1, 0, 1, 0, 0, 6288, SYS, select p.resource#, p.limit# from sys.profile$ p where p.type# = 0 and p.profile# = :profileid, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 147343648, -1, 1, 1, 0, 1, 3792, ADMIN, CALL ttconfiguration ('TTGrid'), 2, 2024-08-29 03:08:39.069000, 0, 0, 0, 0, <NULL>, 1148, 1148, 0, 0 >
< 154652272, -1, 6, 6, 0, 1, 8032, SYS, select owner#,name,namespace,obj#,type#,ctime,mtime,stime,status,flags from sys.obj$ where owner#=:1 and name=:2 and namespace=:3, 6, 2024-08-29 03:08:39.370000, 0, 0, 0, 0, <NULL>, 1022, 1022, 0, 0 >
< 143311952, -1, 0, 1, 0, 0, 9808, SYS, select 1 from sys.sysauth$ s where (s.grantee# = :userid or s.grantee# = 1) and (s.privilege# = :priv or s.privilege# = 67), 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 147411432, -1, 0, 1, 0, 0, 5488, SYS, delete from user_history$ where user# = :userid and password_date < :pdate, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 154654448, -1, 1, 1, 0, 1, 3376, ADMIN, CALL ttOptSetFlag ('passthrough', 0), 0, 2024-08-29 03:08:39.069000, 0, 0, 0, 0, <NULL>, 32, 32, 0, 0 >
< 147399464, -1, 0, 1, 0, 0, 6320, SYS, update sys.user$ u set u.lcount = u.lcount + 1, u.ltime = sysdate, u.astatus = :astatus where u.user# = :userid, 0, <NULL>, 0, <NULL>, 0, 0, <NULL>, 0, 0, 0, 0 >
< 143304432, -1, 1, 1, 0, 0, 7408, 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-08-29 03:08:31.250000, 0, 0, 0, 0, <NULL>, 1312, 1312, 0, 0 >
14 rows found.