DBA_Data_Files&DBA_Tablespaces

DBA_DATA_FILES

DBA_DATA_FILES describes database files.

Column Datatype NULL Description

FILE_NAME

VARCHAR2(513)

Name of the database file

FILE_ID

NUMBER

NOT NULL

File identifier number of the database file

TABLESPACE_NAME

VARCHAR2(30)

NOT NULL

Name of the tablespace to which the file belongs

BYTES

NUMBER

Size of the file in bytes

BLOCKS

NUMBER

NOT NULL

Size of the file in Oracle blocks

STATUS

VARCHAR2(9)

File status: AVAILABLE or INVALID (INVALID means that the file number is not in use, for example, a file in a tablespace that was dropped)

RELATIVE_FNO

NUMBER

Relative file number

AUTOEXTENSIBLE

VARCHAR2(3)

Autoextensible indicator

MAXBYTES

NUMBER

Maximum file size in bytes

MAXBLOCKS

NUMBER

Maximum file size in blocks

INCREMENT_BY

NUMBER

Autoextension increment

USER_BYTES

NUMBER

Corresponding number of bytes

USER_BLOCKS

NUMBER

Number of blocks which can be used by the data

dba_tablespaces的说明

DBA_TABLESPACES

DBA_TABLESPACES describes all tablespaces in the database.

Related View

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

Tablespace name

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

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)

Indicates whether this tablespace is under force logging mode (YES) or not (NO)

EXTENT_MANAGEMENT

VARCHAR2(10)

Indicates how the extents of this tablespace are managed:

DICTIONARY - Tablespace is dictionary managed

LOCAL - Tablespace is locally managed

ALLOCATION_TYPE

VARCHAR2(9)

Type of extent allocation in effect for this tablespace:

SYSTEM

UNIFORM

USER

PLUGGED_IN

VARCHAR2(3)

Indicates whether this tablespace is plugged in (YES) or not (NO)

SEGMENT_SPACE_MANAGEMENT

VARCHAR2(6)

Indicates how the used and free space in the segments in this tablespace are managed:

MANUAL - Segment space in this tablespace is managed using free lists

AUTO - Segment space in this tablespace is managed using bitmaps