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