SELECT r.usn,      r.name,  s.osuser, 
       s.username, 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
