How to identify a session started by a remote distributed transaction? (文档 ID 332326.1)

How to identify a session started by a remote distributed transaction? (文档 ID 332326.1)
如何识别由远程分布式事务启动的会话？
In this Document
Goal
Solution
APPLIES TO:
适用于：
Oracle Database - Enterprise Edition - Version 8.1.7.4 to 12.1.0.1 [Release 8.1.7 to 12.1]
Information in this document applies to any platform.
Oracle数据库企业版的版本8.1.7.4到12.1.0.1 [版本8.1.7到12.1]
本文档中的信息适用于任何平台。


GOAL
目的：


In a distributed database environment it may be required to identify a session
started by a remote distributed transaction, especially to enable tracing. This 
note provides a method to do that.
在分布式数据库环境中，可能需要标识远程分布式事务启动的会话，尤其是启用跟踪。本说明提供了一种方法来做到这一点。
SOLUTION
解决方法：
The following query can be used to identify the session started by a 
distributed transaction
下面的查询可以用来确定分布式事务启动的会话。
select username, osuser, status, sid, serial#, machine, process, terminal, program
from v$session
where saddr in (select k2gtdses from sys.x$k2gte );
 
The fixed table x$k2gte contains 2PC Global Transaction Entry. The column
k2gtdses in x$k2gte has the session state object and this can be mapped to the
saddr column of v$session.
固定表x$k2gte包含2PC的整体业务入口。