|
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 this tablespace
|
|
STATUS
|
VARCHAR2(9)
|
|
Tablespace status:
|
|
CONTENTS
|
VARCHAR2(9)
|
|
Tablespace contents:
|
|
LOGGING
|
VARCHAR2(9)
|
|
Default logging attribute:
|
|
FORCE_LOGGING
|
VARCHAR2(3)
|
|
Indicates whether this tablespace is under force logging mode (YES) or not (NO)
|
|
EXTENT_MANAGEMENT
|
VARCHAR2(10)
|
|
Indicates how the extents of this tablespace are managed:
DICTIONARY - Tablespace is dictionary managedLOCAL - Tablespace is locally managed
|
|
ALLOCATION_TYPE
|
VARCHAR2(9)
|
|
Type of extent allocation in effect for this tablespace:
|
|
PLUGGED_IN
|
VARCHAR2(3)
|
|
Indicates whether this tablespace is plugged in (YES) or not (NO)
|
|
SEGMENT_SPACE_MANAGEMENT
|
VARCHAR2(6)
|
|
Indicates how the used and free space in the segments in this tablespace are managed:
MANUAL - Segment space in this tablespace is managed using free listsAUTO - Segment space in this tablespace is managed using bitmaps
|
