Oracle如何查询表空间？

Question

Oracle如何查询表空间？

Answer 1

系统数据字典 DBA_TABLESPACES 中记录了关于表空间的详细信息：

select * from sys.dba_tablespaces;

数据字典 DBA_TABLESPACES 中的字段和含义:

TABLESPACE_NAME
Tablespace name
BLOCK_SIZE
Tablespace block size
INITIAL_EXTENT
Default initial extent size
NEXT_EXTENT
Default incremental extent size
MIN_EXTENTS
Default minimum number of extents
MAX_EXTENTS
Default maximum number of extents
PCT_INCREASE
Default percent increase for extent size
MIN_EXTLEN
Minimum extent size for the tablespace
STATUS
"Tablespace status: "ONLINE","OFFLINE" or "READ
CONTENTS
Tablespace contents: "PERMANENT" or "TEMPORARY" or "UNDO"
LOGGING
Default logging attribute
FORCE_LOGGING
Tablespace force logging mode
EXTENT_MANAGEMENT
Extent management tracking: "DICTIONARY" or "LOCAL"
ALLOCATION_TYPE
Type of extent allocation in effect for this tablespace
PLUGGED_IN
--
SEGMENT_SPACE_MANAGEMENT
Segment space management tracking: "AUTO" or "MANUAL"