select * from dba_tablespaces

TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FORCE_LOGGING EXTENT_MANAGEMENT ALLOCATION_TYPE PLUGGED_IN SEGMENT_SPACE_MANAGEMENT DEF_TAB_COMPRESSION
SYSTEM 16384 32768 16384 1 1017 50 0 ONLINE PERMANENT LOGGING NO DICTIONARY USER NO MANUAL DISABLED
UNDOTBS 16384 65536 null 1 2147483645 null 65536 ONLINE UNDO LOGGING NO LOCAL SYSTEM NO MANUAL DISABLED
TEMP 16384 1048576 1048576 1 null 0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL UNIFORM NO MANUAL DISABLED
BLOBS 16384 131072 131072 1 2147483645 0 131072 ONLINE PERMANENT LOGGING NO LOCAL UNIFORM NO AUTO DISABLED
INDX 16384 131072 131072 1 2147483645 0 131072 ONLINE PERMANENT LOGGING NO LOCAL UNIFORM NO AUTO DISABLED
TOOLS 16384 1048576 null 1 2147483645 null 1048576 ONLINE PERMANENT LOGGING NO LOCAL SYSTEM NO AUTO DISABLED
USERS 16384 131072 131072 1 2147483645 0 131072 ONLINE PERMANENT LOGGING NO LOCAL UNIFORM NO AUTO DISABLED