DBA_Data_Files & DBA_Tablespaces
2024-07-21 02:37:59
供稿：網友
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 right">（出處：清風軟件下載學院）
