Timesten obtains SQL-related execution plans and timesten execution plans

Timesten obtains SQL-related execution plans and timesten execution plans

Command> host ttxactadmin ttwind

Command> call ttsqlcmdcacheinfo (135710768 );

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 sql1_id Name

Program File Name: timestenorad

9100 0x7fe5ac0811e0 8.2397 Active Database 0x01312d0001312d00 IX 0
Table 1798032 W 10739348336 SCOTT. TBLORDERS
Row bmufvuaaaabaajbv S 10739348336 SYS. TABLES
Row BMUFVUAAABHFQAAEhm Sn 10739348336 SYS. CACHE_GROUP

1 outstanding transaction found

Command> call ttsqlcmdcacheinfo (10739348336 );

<10739348336,204 8, 425,425, 0, 1, 2272, SYS, CALL ttCacheLockCacheGp (1, '192 # ','s', '1')>
1 row found.

 

 

Command> vertical 1;

Command> call ttsqlcmdcacheinfo (10739348336 );

Sqlbench ID: 10739348336
PRIVATE_COMMAND_CONNECTION_ID: 2048
EXECUTIONS: 426
PREPARES: 426
REPREPARES: 0
FREEABLE: 1
SIZE: 2272
OWNER: SYS
QUERYTEXT: CALL ttCacheLockCacheGp (1, '1970 # ', 's', '1 ')

Command> call ttsql1_queryplan (10739348336 );

Sqlbench ID: 10739348336
QUERYTEXT: CALL ttCacheLockCacheGp (1, '1970 # ', 's', '1 ')
STEP: <NULL>
LEVEL: <NULL>
OPERATION: <NULL>
TABLENAME: <NULL>
TABLEOWNERNAME: <NULL>
INDEXNAME: <NULL>
INDEXEDPRED: <NULL>
NONINDEXEDPRED: <NULL>

Sqlbench ID: 10739348336
QUERYTEXT: <NULL>
STEP: 1
LEVEL: 1
OPERATION: Procedure Call
TABLENAME:
TABLEOWNERNAME:
INDEXNAME:
INDEXEDPRED:
NONINDEXEDPRED:

 

Command> commit;