Table: DBA_DATA_FILES
Information about database data files
Column Name | Description |
---|---|
AUTOEXTENSIBLE | Autoextensible indicator: "YES" or "NO" |
BLOCKS | Size of the file in ORACLE blocks |
BYTES | Size of the file in bytes |
FILE_ID | ID of the database data file |
FILE_NAME | Name of the database data file |
INCREMENT_BY | Default increment for autoextension |
MAXBLOCKS | Maximum size of the file in ORACLE blocks |
MAXBYTES | Maximum size of the file in bytes |
RELATIVE_FNO | Tablespace-relative file number |
STATUS | File status: "INVALID" or "AVAILABLE" |
TABLESPACE_NAME | Name of the tablespace to which the file belongs |
USER_BLOCKS | Size of the useful portion of file in ORACLE blocks |
USER_BYTES | Size of the useful portion of file in bytes |