Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-12
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_TEMP_FILES

DBA_TEMP_FILES describes all temporary files (tempfiles) in the database.

Column Datatype NULL Description
FILE_NAME VARCHAR2(513)   Name of the database temp file
FILE_ID NUMBER   File identifier number of the database temp file
TABLESPACE_NAME VARCHAR2(30) NOT NULL Name of the tablespace to which the file belongs
BYTES NUMBER   Size of the file (in bytes)
BLOCKS NUMBER   Size of the file (in Oracle blocks)
STATUS CHAR(9)   File status:
  • OFFLINE

  • ONLINE

  • UNKNOWN

RELATIVE_FNO NUMBER   Tablespace-relative file number
AUTOEXTENSIBLE VARCHAR2(3)   Indicates whether the file is autoextensible (YES) or not (NO)
MAXBYTES NUMBER   maximum size of the file (in bytes)
MAXBLOCKS NUMBER   Maximum size of the file (in Oracle blocks)
INCREMENT_BY NUMBER   Default increment for autoextension (in Oracle blocks)
USER_BYTES NUMBER   Size of the useful portion of the file (in bytes)
USER_BLOCKS NUMBER   Size of the useful portion of the file (in Oracle blocks)