Oracle FAQ: 如何找到使用 DB Link 连接数据库的会话

一个常见问题：How can I tell what users are on an active database link?

一个示范脚本：

Select /*+ ORDERED */
substr(s.ksusemnm,1,10)||'-'|| substr(s.ksusepid,1,10)      "ORIGIN",
substr(g.K2GTITID_ORA,1,35)                                 "GTXID",
substr(s.indx,1,4)||'.'|| substr(s.ksuseser,1,5)            "LSESSION" ,
s2.username,
substr(
   decode(bitand(ksuseidl,11),
      1,'ACTIVE',
      0, decode( bitand(ksuseflg,4096) , 0,'INACTIVE','CACHED'),
      2,'SNIPED',
      3,'SNIPED',
      'KILLED'
   ),1,1
) "S",
substr(w.event,1,10) "WAITING"
from 
   x$k2gte g,
   x$ktcxb t,
   x$ksuse s,
   v$session_wait w,
   v$session s2
where 
   g.K2GTDXCB =t.ktcxbxba
and  
   g.K2GTDSES=t.ktcxbses
and 
   s.addr=g.K2GTDSES
and 
   w.sid=s.indx
and
   s2.sid = w.sid;