v$transaction的addr和v$session的taddr对应可以找到session,
v$session下面有sql_address,sql_hash_value可以找到对应v$sql或者v$sql_text里的sql语句。
select /*+ rule*/c.SQL_TEXT
from v$transaction a, v$session b, v$sql c
where a.XIDUSN = &XIDUSN
and a.XIDSLOT = &XIDSLOT
and a.XIDSQN = &XIDSQN
and a.ADDR = b.TADDR
and b.SQL_ADDRESS = c.ADDRESS
and b.SQL_HASH_VALUE = c.HASH_VALUE;
另见:《
根据PID查询正在执行的SQL语句 》