Select * from V$rollstat;
Select * from V$rollname;
Select * from V$SEGMENT_STATISTICS WHERE TABLESPACE_NAME LIKE 'S%';

Select * from DBA_ROLLBACK_SEGS;
select a.name,a2.writes from V$rollname a, v$rollstat a2
where a.usn=a2.usn;

select a.name,round(100*a2.waits/a2.gets) Rywalizacje
from v$rollname a, v$rollstat a2
where a.usn=a2.usn;

select segment_name, status from dba_rollback_segs;


select rn.Name "Rollback Segment", rs.RSSize/1024 "Size(KB)", rs.Gets "Gets",
rs.waits "Waits",(rs.Waits/rs.Gets)*100 "% Waits",
rs.Shrinks "# Shrinks", rs.Extends "# Extends"
From sys.v_$rollName rn, sys.v_$rollstat rs
where rn.usn=rs.usn;