rbs_who.sql
Download Script
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;