Oracle XID

Query to find session details for an Oracle XID sometimes listed in Goldengate info.


col username format a32
select s.inst_id, s.sid, s.serial#, s.username, s.status, s.event, s.type, s.paddr, s.taddr, p.spid from gv$session s, gv$process p, gv$transaction t
where s.inst_id = p.inst_id and s.inst_id = t.inst_id and s.paddr = p.addr and s.taddr = t.addr and '0'||'.'||xidusn||'.'||xidslot||'.'||xidsqn = '&xid';