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