rb.sql

rem ======================================================================
rem Name:  rb.sql
rem Desc:  Rollback segments
rem
rem ======================================================================

rem Set the general display parameters for the report:
set pages 55
set lines 79
set pause off
set echo off
set feed 1
set termout on

rem Capture the current date and time:
set termout off
col currdate new_value now
select to_char(sysdate, 'mm/dd/yy hh24:mi') currdate from dual;
set termout on

rem The title for the report:
ttitle left   "rb.sql" -
       center "Rollback Segments" -
       right  "Page:" sql.pno  skip 1 -
       right  "Date: " now  skip 3 

col segment_name form a20 head 'SEGMENT NAME'
col tablespace_name form a20 head 'TABLESPACE NAME'
col bytes form 999,999,999,999 head 'BYTES'
col extents form 999 head 'EXTENTS'


SELECT segment_name, tablespace_name, bytes, extents
   FROM sys.dba_segments
   WHERE segment_type = 'ROLLBACK';

spool rb.lst
/
spool off

exit