Rollback Segments - List performance data
-- Rollback segments - list performance data
-- @oracle/tuning/rbs_performance.sql
--
column name format a10
select name,WAITS,SHRINKS,WRAPS,EXTENDS        
from v$rollstat, v$rollname
where v$rollstat.usn = v$rollname.usn;