spool rlbk_seg.rslt 

set linesize 80;
set pagesize 1000;
set long 50;
set echo on;

/* ****************************************************** */
/*                                                        */
/*  - show the rollback segments, status and size for a   */
/*    given database instance                             */
/*                                                        */
/*         @c:\oracle\sql\rlbk_seg.sql                    */ 
/*                                                        */
/* ****************************************************** */

select  substr(segment_name,1,10)	  "RBS",
        substr(owner,1,10)                "OWNER",
        substr(tablespace_name,1,10)      "TBL SPC",
        initial_extent,
	next_extent,
	status
from dba_rollback_segs 
order by 1, 2,3,4,5;

set echo off;
spool off;
set long 80;
commit;









