oracle怎么查表空间,Oracle如何查询表空间？

系统数据字典 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"