prompt

prompt Rollback Segment Usage

prompt ======================

column name format a10

column usn format 99

column sid format 999

column xacts format 9999

column extents format 999999

column extends format 99999

column waits format 9999

column wraps format 9999

column shrnk format 9999

column name format a12

column osusr format a6


SELECT distinct r.usn,r.name,s.osuser osusr,s.sid,x.extents,x.xacts,x.extends,x.waits,x.shrinks shrnk,
x.wraps, x.writes FROM   
v$rollstat X,v$rollname R, v$session S,v$transaction T
WHERE  t.addr       = s.taddr (+)
AND    x.usn (+)    = r.usn
AND    t.xidusn (+) = r.usn
ORDER  BY r.usn
/