v$ Performance views

DBA_DATA_FILES

Information about database data files

Columns
   ___________________________
 
   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:

v$datafile - (datafile information from the control file)



Back to the Top

Simon Sheppard
SS64.com