Command>host Ttxactadmin Ttwind
Command>call Ttsqlcmdcacheinfo (135710768);
2014-12-30 16:07:54.311
/app/timesten/timesten/ttwind/info/datastore/ttwind
TimesTen Release 11.2.2.7.0
Outstanding locks
PID Context transid transstatus Resource ResourceID Mode sqlcmdid Name
Program File Name:timestenorad
9100 0x7fe5ac0811e0 8.2397 Active Database 0x01312d0001312d00 IX 0
Table 1798032 W 10739348336 SCOTT. Tblorders
Row bmufvuaaaabaaaajbv S 10739348336 SYS. TABLES
Row Bmufvuaaabhfqaaehm Sn 10739348336 SYS. Cache_group
1 Outstanding transaction found
Command>call Ttsqlcmdcacheinfo (10739348336);
< 10739348336, 2048, 425, 425, 0, 1, 2272, SYS, call TTCACHELOCKCACHEGP (1, ' 357000776# ', ' S ', ' 1 ') >
1 row found.
Command>vertical 1;
Command>call Ttsqlcmdcacheinfo (10739348336);
sqlcmdid:10739348336
private_command_connection_id:2048
executions:426
prepares:426
reprepares:0
Freeable:1
size:2272
Owner:sys
Querytext:call TTCACHELOCKCACHEGP (1, ' 357000776# ', ' S ', ' 1 ')
Command>call Ttsqlcmdqueryplan (10739348336);
sqlcmdid: 10739348336
querytext: Call TTCACHELOCKCACHEGP (1, ' 357000776# ', ' S ', ' 1 ')
step: <null>
level: <null>
operation: <null>
tablename: <null>
Tableownername : <null>
indexname: <NULL>
indexedpred: <null>
nonindexedpred: <NULL>
sqlcmdid:10739348336
QueryText: <NULL>
Step:1
Level:1
Operation:procedure Call
TABLENAME:
Tableownername:
IndexName:
Indexedpred:
Nonindexedpred:
command>commit;
TimesTen getting SQL-related execution plans