|
DBA_DATA_FILES
Information about database data filesColumns ___________________________ AUTOEXTENSIBLE Autoextensible indicator: `YES` or `NO` USER_BLOCKS Size of the useful portion of file in ORACLE blocks USER_BYTES Size of the useful portion of file in bytes 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` BLOCKS Size of the file in ORACLE blocks BYTES Size of the file in bytes FILE_ID ID of the database data file TABLESPACE_NAME Name of the tablespace to which the file belongs
Related Commands:
DBA_TEMP_FILES - List temporary files.
v$datafile - List data files (datafile
information from the control file)