How to identify a session started by a remote distributed transaction? (文档 ID 332326.1)admin管理员组文章数量:1654022
如何识别由远程分布式事务启动的会话?
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的整体业务入口。
本文标签: 文档startedRemotesessionidentify
版权声明:本文标题:How to identify a session started by a remote distributed transaction? (文档 ID 332326.1) 内容由热心网友自发贡献,该文观点仅代表作者本人, 转载请联系作者并注明出处:https://www.elefans.com/dongtai/1729650680a1209002.html, 本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容,一经查实,本站将立刻删除。
发表评论