V$ROLLSTAT XACTS Field

[tamilselvan]

-- Active Rollback segment

select A.xidusn RBS_NO, A.ADDR, B.USERNAME, B.SADDR
from V$TRANSACTION A, v$session B
where A.ADDR = B.TADDR AND username = 'SCOTT' ;