select tablespace_name, initial_extent, next_extent, pct_increase, min_extlen
from dba_tablespaces
where (initial_extent not in (160*1024, 5120*1024, 160*1024*1024)
or next_extent != initial_extent
or pct_increase != 0
or min_extlen != initial_extent)
and contents = ‘PERMANENT’
and tablespace_name!=’SYSTEM’
and tablespace_name not in (select tablespace_name from dba_rollback_segs)

How to check your tablespace setup
Tagged on:

Leave a Reply

Your email address will not be published. Required fields are marked *

9 + one =