SQL> desc dba_tablespaces
Name Type Nullable Default Comments
------------------------ ------------ -------- ------- --------------------------------------------------------------------
TABLESPACE_NAME VARCHAR2(30) Tablespace name
BLOCK_SIZE NUMBER Tablespace block size
INITIAL_EXTENT NUMBER Y Default initial extent size
NEXT_EXTENT NUMBER Y Default incremental extent size
MIN_EXTENTS NUMBER Default minimum number of extents
MAX_EXTENTS NUMBER Y
MAX_SIZE NUMBER Y Default maximum size of segments
PCT_INCREASE NUMBER Y Default percent increase for extent size
MIN_EXTLEN NUMBER Y Minimum extent size for the tablespace
STATUS VARCHAR2(9) Y Tablespace status: "ONLINE", "OFFLINE", or "READ ONLY"
CONTENTS VARCHAR2(9) Y Tablespace contents: "PERMANENT", or "TEMPORARY"
LOGGING VARCHAR2(9) Y Default logging attribute
FORCE_LOGGING VARCHAR2(3) Y Tablespace force logging mode
EXTENT_MANAGEMENT VARCHAR2(10) Y Extent management tracking: "DICTIONARY" or "LOCAL"
ALLOCATION_TYPE VARCHAR2(9) Y Type of extent allocation in effect for this tablespace
PLUGGED_IN VARCHAR2(3) Y
SEGMENT_SPACE_MANAGEMENT VARCHAR2(6) Y Segment space management tracking: "AUTO" or "MANUAL"
DEF_TAB_COMPRESSION VARCHAR2(8) Y Default compression enabled or not: "ENABLED" or "DISABLED"
RETENTION VARCHAR2(11) Y Undo tablespace retention: "GUARANTEE", "NOGUARANTEE" or "NOT APPLY"
BIGFILE VARCHAR2(3) Y Bigfile tablespace indicator: "YES" or "NO"
PREDICATE_EVALUATION VARCHAR2(7) Y Predicates evaluated by: "HOST" or "STORAGE"
ENCRYPTED VARCHAR2(3) Y Encrypted tablespace indicator: "YES" or "NO"
COMPRESS_FOR VARCHAR2(18) Y Default compression for what kind of operations
红色标识的字段到底表示什么,照字面意思理解的话"segment的最大大小"的话
select distinct round(max_size/1024/1024)
from dba_tablespaces;
---------------------------------------------------------
2048
那么意思segment的最大大小只能是2Gbytes,但是现实中超过2G的segment多了去了。于是产生的困惑,请达人指点