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
Get Oracle Database 11gR2 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.