DBA_TEMP_FILES
This view shows all temporary files in the database.
Fields
The most relevant view fields are as follows:
FILE_ID
: A unique ID associated to the fileFILE_NAME
: The name of the temporary fileTABLESPACE_NAME
: The name of the tablespace to which the file belongsBYTES
: The size in bytesBLOCKS
: The size in database blocks
See also
The
DBA_EXTENTS
,FILE$
,V$DATAFILE
,V$LOGFILE
,DBA_DATA_FILES
, andV$CONTROLFILE
sections in this appendix