select *
from v$rollname
where usn = (select xidusn
from v$transaction
where addr in (select taddr
from v$session
where sid=&session_id));