rollstat.sql

select segment_name, tablespace_name, status from dba_rollback_segs;