timesten擷取sql相關執行計畫，timesten執行計畫

timesten擷取sql相關執行計畫，timesten執行計畫

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;