timesten获取sql相关执行计划

最新推荐文章于 2021-04-16 09:16:09 发布

Angus_yang

最新推荐文章于 2021-04-16 09:16:09 发布

阅读量2.4k

点赞数

分类专栏： timesten

本文链接：https://blog.csdn.net/yangzhawen/article/details/42268181

版权

timesten 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

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;