Trafodion QUERY-ID 详解

最新推荐文章于 2024-06-20 11:34:18 发布

数据源的港湾

最新推荐文章于 2024-06-20 11:34:18 发布

阅读量2.9k

点赞数 1

分类专栏： QianBase/EsgynDB/Trafodion

本文链接：https://blog.csdn.net/post_yuan/article/details/78950453

版权

QianBase/EsgynDB/Trafodion 专栏收录该内容

263 篇文章 3 订阅

订阅专栏

Trafodion中每一个执行的Query都具有唯一的标识，我们称之为QUERY-ID，QUERY-ID是唯一的，当某一个具体的SQL语句被编译后，QUERY-ID即生成用来标识特定的SQL语句。

QUERY-ID从表面上看是一串特定的字符串，如MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__，实际上QUERY-ID字符串中包含了很多信息。下面列表描述了QUERY-ID中包含的信息，

参数	描述
SEGMENTNUM	节点ID
CPUNUM 或 CPU	节点ID
PIN	Linux进程号
EXESTARTTIME	起始时间
SESSIONNUM	SESSION编号
USERNAME	执行用户
SESSIONNAME	SESSION名称
SESSIONID	SESSION标识
QUERYNUM	查询编号
STMTNAME	句柄

下面我们通过一个实际的QUERY-ID查看其各项参数的值分别是什么吧。

1 SEGMENTNUM、CPU

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','SEGMENTNUM') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

0
>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','CPU') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

0

2 PIN

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','PIN') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

13545

3 EXESTARTTIME

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','EXESTARTTIME') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

212381624386556109

4 SESSIONNUM

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','SESSIONNUM') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

2

5 USERNAME

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','USERNAME') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

U33333

6 SESSIONNAME

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','SESSIONNAME') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

7 SESSIONID

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','SESSIONID') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

MXID11000013545212381624386556109000000000206U3333300

8 QUERYNUM

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','QUERYNUM') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

104

9 STMTNAME

>>select queryid_extract('MXID11000013545212381624386556109000000000206U3333300_104___SQLCI_DML_LAST__','STMTNAME') from dual;

(EXPR)
----------------------------------------------------------------------------------------------------------------------------------------------------------------

__SQLCI_DML_LAST__