/* ************************************************ */
/*                                                  */
/* fnctn:   Rollback Segment Report                 */
/*                                                  */
/* name:    @c:\oracle\sql\rbsegrpt.sql             */
/* date:    12-MAY-95                               */
/* creator: Rick Kupcunas (Oracle)                  */
/*                                                  */
/* ************************************************ */

set feedback  off
set wrap      off
set pagesize  60
set linesize  78
set newpage   0
set trimout   on
set verify    on
set space     2
set underline =
set echo      off
set termout   off

whenever sqlerror exit failure

spool rbsegrpt.rslt

ttitle left 'RBSEGRPT - Rollback Segment Report ' right CWS_DATE skip 2

column segment_name          format A12          heading Segment
column owner                 format A5
column tablespace_name       format A7          heading Tbspace
column initial_extent        format 99,999,999  heading Initial
column next_extent           format 99,999,999  heading Next
column min_extents           format 999          heading Min
column max_extents           format 999          heading Max
column status                format A10

select segment_name, 
     owner, 
     tablespace_name, 
     status, 
     initial_extent, 
     next_extent, 
     min_extents, 
     max_extents
from sys.dba_rollback_segs
order by tablespace_name, segment_name;

spool off
exit
