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__