DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 24, 2012

To identify the Segments Unable to extend


Segments in TS unable to extend

set linesize 150
select tablespace_name||'   '||owner||'  '||segment_name||'  '||next_extent||'   '||segment_type||'  '||pct_increase from
dba_segments
where tablespace_name ='&tbs' and next_extent > (select max(BYTES) from  dba_free_space where
tablespace_name ='&tbs')
order by next_extent;

set linesize 150
select a.tablespace_name||'   '||a.owner||'  '||a.segment_name||'  '||a.next_extent||'   '||a.segment_type from
dba_segments a,dba_free_space b
where a. tablespace_name=b.tablespace_name and a.next_extent > (select max(BYTES) from  dba_free_space where
tablespace_name =a.tablespace_name)
order by next_extent;

No comments: