Please get session detail for transaction 95.22.1516570 (Replace with your transaction id)

select
t1.sid,
t1.username,
t2.xidusn,
t2.used_urec,
t2.used_ublk
from
v$session t1,
v$transaction t2
where
t1.saddr = t2.ses_addr;
and t2.XIDUSN = 95
and t2.XIDSLOT = 22
and t2.XIDSQN = 1516570

Recommended Posts

Start typing and press Enter to search