list rollback segment details.sql

on June 23, 2008 at 12:33 pm
Posted In: Oracle DB and SQL performance analysis (Cat)

— rbs_dets.sql
— mdw 02/02/00
— list of rollback seg details
set pause on pages 30 pause ‘Any Key..> ‘
col owner form a7
col instance_num form a1 head I
col rb_name form a15 wrap
col ts_name form a12 wrap
col ini_e_k form 999,999
col nxt_e_k form 999,999
col min_e form 999
col max_e form 99,999
col stat  form A7
spool rbs_dets.lst
—
select
owner
,instance_num
,segment_name     rb_name
,tablespace_name   ts_name
,initial_extent/1024    ini_e_k
,next_extent/1024       nxt_e_k
,min_extents       min_e
,max_extents       max_e
,status            stat
from dba_rollback_segs
order by owner,segment_name
/
spool off
clear col
— EOF