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

VARCHAR2(7)

 

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)