kumaresan

• Sep 12th, 2006

 

This is the simple query which gives objects nearing to maxextents

select segment_name,segment_owner from dba_segments where max_extents-extents=0;

kumaresan.m

 Profile 

• Sep 12th, 2006

 

a simple query which  tells objects reaching maxextents

sql> select segment_name,segment_owner from dba_segments where   max_extents-extents=0;