rback.sql

rem ======================================================================
rem Name:  rback.sql
rem Desc:  Display info about 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   "rback.sql" -
       center "Rollback segment" -
       right  "Page:" sql.pno  skip 1 -
       right  "Date: " now  skip 3 


SELECT segment_name, tablespace_name, status
   FROM sys.dba_rollback_segs;





spool rback.lst
/
spool off

exit