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 file
  • FILE_NAME: The name of the temporary file
  • TABLESPACE_NAME: The name of the tablespace to which the file belongs
  • BYTES: The size in bytes
  • BLOCKS: The size in database blocks

See also

  • The DBA_EXTENTS, FILE$, V$DATAFILE, V$LOGFILE, DBA_DATA_FILES, and V$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.