select segment_name, status from dba_rollback_segs order by status, segment_name;
select status, count(1) from dba_rollback_segs group by status;
select segment_name, status from dba_rollback_segs order by status, segment_name;
select status, count(1) from dba_rollback_segs group by status;