select
       rn.usn "Rollback segment number",
       rn.name "Rollback segment name",
       sess.schemaname "User",
       o.name "Table Name"
from
       v$rollname rn,
       v$session sess,
       obj$ o,
       v$newlock lck1,
       v$newlock lck2,
       v$transaction t
where
       lck1.addr = t.addr
and    lck1.sid = sess.sid
and    lck2.id1 = o.obj#
and    lck1.sid = lck2.sid
and    t.xidusn = rn.usn;
