DBA_DATA_FILES
describes database files.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Name of the database file |
|
|
|
File identifier number of the database file |
|
|
|
Name of the tablespace to which the file belongs |
|
|
|
Size of the file in bytes |
|
|
|
Size of the file in Oracle blocks |
|
|
|
File status: |
|
|
|
Relative file number |
|
|
|
Autoextensible indicator |
|
|
|
Maximum file size in bytes |
|
|
|
Maximum file size in blocks |
|
|
|
Number of Oracle blocks used as autoextension increment |
|
|
|
The size of the file available for user data. The actual size of the file minus the |
|
|
|
Number of blocks which can be used by the data |
|
|
|
Online status of the file:
|