DBA-TABLESPACES.doc

DBA_TABLESPACES
dba_tablespaces描述了数据库中的所有的表空间的信息：DBA_TABLESPACES describes all tablespaces in the database.
相关视图：Related View
user_tablespaces数据字典视图当前用户可以访问的表空间的信息，此视图中没有plugged_in字段。其它的信息与dba_tablespaces显示的信息相同.:USER_TABLESPACES describes the tablespaces accessible to the current user. This view does not display the PLUGGED_IN column.
字段:Column
数据类型：Datatype
是否为空：NULL
描述：Description
TABLESPACE_NAME
VARCHAR2(30)
NOT NULL
表空间的名字：Name of the tablespace
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
MAX_SIZE
NUMBER

默认最大的段大小：Default maximum size of segments
PCT_INCREASE
NUMBER

默认区增长的百分比：Default percent increase for extent size
MIN_EXTLEN
NUMBER

此表空间的最小的区大小：Minimum extent size for this tablespace
STATUS
VARCHAR2(9)

表空间的状态：Tablespace status:
· 联机：ONLINE
· 脱机：OFFLINE
· 只读：READ ONLY
CONTENTS
VARCHAR2(9)

表空间的内容：Tablespace contents:
· 回滚表空间：UNDO
· 永久表空间：PERMANENT
· 临时表空间：TEMPORARY
LOGGING
VARCHAR2(9)

默认日志属性：Default logging attribute:
· 开启日志：LOGGING
· 关闭日志：NOLOGGING
FORCE_LOGGING
VARCHAR2(3)

说明表空间是否是处在强制日志模式下，值为yes,no:Indicates whether the tablespace is under force logging mode (YES) or not (NO)
EXTENT_MANAGEMENT
VARCHAR2(10)

说明表空间是本地管理的表空间，还是数据字典管理的表空间：Indicates whether the extents in the tablespace are dictionary managed (DICTIONARY) or locally managed (LOCAL)
ALLOCATION_TYPE
VARCHAR2(9)

Type of extent allocation in effect for the tablespace:
· SYSTEM
· UNIFORM
· USER
PLUGGED_IN
VARCHAR2(3)

Indicates whether the tablespace is plugged in (YES) or not (NO)
SEGMENT_SPACE_MANAGEMENT
VARCHAR2(6)

说明表空间管理是自动的还是手工的，值有manual和auto:Indicates whether the free and used segment space in the tablespace is managed using free lists (MANUAL) or bitmaps (AUTO)
DEF_TAB_COMPRESSION
VARCHAR2(8)

说明默认的表压缩是否开启，值有enbale,disanle:Indicates whether default table compression is enabled (ENABLED) or not (DISABLED)
注意，当开启此表空间的默认的表压缩时,所有的此表空间中的表在创建的时候都会默认带有压缩特性，除非你在创建表时明确指出了不使用压缩特性：Note: Enabling default table compression indicates that all tables in the tablespace will be created with table compression enabled unless otherwise specified.
RETENTION
VARCHAR2(11)

Undo tablespace retention:
· GUARANTEE - Tablespace is an undo tablespace with RETENTION specified as GUARANTEE
A RETENTION value of GUARANTEE indicates that unexpired undo in all undo segments in the undo tablespace should be retained even if it means that forward going operations that need to generate undo in those segments fail.
· NOGUARANTEE - Tablespace is an undo tablespace with RETENTION specified as NOGUARANTEE
· NOT APPLY - Tablespace is not an undo tablespace
BIGFILE
VARCHAR2(3)

说明此表空间是大文件表空间或小文件表空间：Indicates whether the tablespace is a bigfile tablespace (YES) or a smallfile tablespace (NO)
PREDICATE_EVALUATION
VARCHAR2(7)

Indicates whether predicates are evaluated by host (HOST) or by storage (STORAGE)
ENCRYPTED
VARCHAR2(3)

说明此表空间是否被加密的，值有yes,no:Indicates whether the tablespace is encrypted (YES) or not (NO)