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 |
|
Number of tablespace blocks used as autoextension increment. Block size is contained in the BLOCK_SIZE column of the DBA_TABLESPACES view. |
USER_BYTES |
NUMBER |
|
The size of the file available for user data. The actual size of the file minus the USER_BYTES value is used to store file related metadata. |
USER_BLOCKS |
NUMBER |
|
Number of blocks which can be used by the data |
ONLINE_STATUS |
VARCHAR2(7) |
|
Online status of the file:
-
SYSOFF
-
SYSTEM
-
OFFLINE
-
ONLINE
-
RECOVER
|
