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;