rbk_lcks.sql

SELECT r.usn,      substr(r.name,1,5) RB_NAME,  substr(s.osuser,1,8) OSUSER,
       substr(s.username,1,5) "NAME", s.sid,   x.extents, 
       x.extends,  x.waits, x.shrinks,
       x.wraps
FROM   sys.v_$rollstat X,
       sys.v_$rollname R,  
       sys.v_$session S,
       sys.v_$transaction T
WHERE  t.addr       = s.taddr (+)
AND    x.usn (+)    = r.usn
AND    t.xidusn (+) = r.usn
ORDER
    BY r.usn
/