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
 

---