TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
Tablespace name |
BLOCK_SIZE |
NUMBER |
NOT NULL |
Tablespace block size |
INITIAL_EXTENT |
NUMBER |
|
Default initial extent size |
NEXT_EXTENT |
NUMBER |
|
Default incremental extent size |
MIN_EXTENTS |
NUMBER |
NOT NULL |
Default minimum number of extents |
MAX_EXTENTS |
NUMBER |
|
Default maximum number of extents |
PCT_INCREASE |
NUMBER |
|
Default percent increase for extent size |
MIN_EXTLEN |
NUMBER |
|
Minimum extent size for the tablespace |
STATUS |
VARCHAR2(9) |
|
Tablespace status (ONLINE , OFFLINE , or READ ONLY ) |
CONTENTS |
VARCHAR2(9) |
|
Tablespace contents (PERMANENT , or TEMPORARY ) |
LOGGING |
VARCHAR2(9) |
|
Default logging attribute |
EXTENT_MANAGEMENT |
VARCHAR2(10) |
|
Extent management tracking (DICTIONARY or LOCAL ) |
ALLOCATION_TYPE |
VARCHAR2(9) |
|
Type of extent allocation in effect for this tablespace |
PLUGGED_IN |
VARCHAR2(3) |
|
YES indicates the tablespace is plugged in; NO indicates the tablespace is not plugged in |
SEGMENT_SPACE_MANAGEMENT |
VARCHAR2(9) |
|
(AUTO |MANUAL ) Indicates whether or not the segment management in this tablespace is managed using free lists (MANUAL ) or bitmaps (AUTO ) |