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
|