Column Name
Description
ALLOCATION_TYPE
Type of extent allocation in effect for this tablespace
BLOCK_SIZE
Tablespace block size
CONTENTS
Tablespace contents: "PERMANENT", or "TEMPORARY"
DEF_TAB_COMPRESSION
Default compression enabled or not: "ENABLED" or "DISABLED"
EXTENT_MANAGEMENT
Extent management tracking: "DICTIONARY" or "LOCAL"
FORCE_LOGGING
Tablespace force logging mode
INITIAL_EXTENT
Default initial extent size
LOGGING
Default logging attribute
MAX_EXTENTS
Default maximum number of extents
MIN_EXTENTS
Default minimum number of extents
MIN_EXTLEN
Minimum extent size for the tablespace
NEXT_EXTENT
Default incremental extent size
PCT_INCREASE
Default percent increase for extent size
PLUGGED_IN
SEGMENT_SPACE_MANAGEMENT
Segment space management tracking: "AUTO" or "MANUAL"
STATUS
Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY"
TABLESPACE_NAME
Tablespace name
'Database > Oracle' 카테고리의 다른 글
USER_CONS_COLUMNS (0) | 2010.04.22 |
---|---|
DBA_USERS (0) | 2010.04.22 |
DBA_OBJECTS (0) | 2010.04.22 |
Hash Partition (0) | 2010.04.12 |
오라클 기본 용어들 (0) | 2010.04.08 |