DBA FUS‎ > ‎

Identify Segments That Are Getting Close To Their Max-Extent Values

posted Sep 11, 2010, 5:17 AM by Sachchida Ojha
select owner,tablespace_name,segment_name,bytes,extents,max_extents
from dba_segments
where extents*2 > max_extents;
Comments