select t.next_extent, t.pct_increase, t.extent_management, t.allocation_type, t.segment_space_management from dba_tablespaces t where t.contents='PERMANENT' NEXT_EXTENT PCT_INCREASE EXTENT_MANAGEMENT ALLOCATION_TYPE SEGMENT_SPACE_MANAGEMENT ----------- ------------ ----------------- --------------- ------------------------ LOCAL SYSTEM MANUAL LOCAL SYSTEM AUTO LOCAL SYSTEM AUTO LOCAL SYSTEM AUTO LOCAL SYSTEM AUTO LOCAL SYSTEM AUTO LOCAL SYSTEM AUTO LOCAL SYSTEM AUTO