DBA_TEMP_FILES

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

Related: