Information about database 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