DBA_TEMP_FILES

Columns
   ___________________________
 
   STATUS
      File status: `AVAILABLE`
   USER_BLOCKS
      Size of the useful portion of file in ORACLE blocks
   USER_BYTES
      Size of the useful portion of file in bytes
   INCREMENT_BY
      Default increment for autoextension
   MAXBLOCKS
      Maximum size of the file in ORACLE blocks
   MAXBYTES
      Maximum size of the file in bytes
   BLOCKS
      Size of the file in ORACLE blocks
   BYTES
      Size of the file in bytes
   TABLESPACE_NAME
      Name of the tablespace to which the file belongs
   FILE_ID
      ID of the database temp file
   FILE_NAME
      Name of the database temp file
   RELATIVE_FNO
      Tablespace-relative file number
   AUTOEXTENSIBLE
      Autoextensible indicator:  `YES` or `NO`

Related Views:

DBA_DATA_FILES - List data files.