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 |