怎么分辨一个session是由分布式事务启动的？

msdnchina

于 2018-03-28 22:37:00 发布

阅读量302

点赞数

文章标签： oracle session 分布式事务 distributed transaction

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文提供了一种方法来识别由远程分布式事务启动的会话，这对于分布式数据库环境中的跟踪尤其有用。通过查询V$SESSION视图并使用X$K2GTE表中的信息，可以确定这些特定会话。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

参考自：

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

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.

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.