暂无图片
如何找到使用 DB Link 连接数据库的会话
最近更新:2023-07-17 14:39:58

脚本功能

-- who is querying via dblink? -- Courtesy of Tom Kyte, via Mark Bobak -- this script can be used at both ends of the database link -- to match up which session on the remote database started -- the local transaction -- the GTXID will match for those sessions -- just run the script on both databases 脚本分为 9I及以下版本和 10g及以上版本。

脚本使用示例

-- for 9I and below

-- who is querying via dblink?
-- Courtesy of Tom Kyte, via Mark Bobak
-- this script can be used at both ends of the database link
......