Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

rbs_header_details.sql

Download Script

set pages 100
col segment_name for a20
ttitle 'Rollback segment file # and block # for header block...'
select segment_name, header_file, header_block
from dba_segments
where segment_type = 'ROLLBACK';
ttitle off