6.50 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)

SHARED

VARCHAR2(12)

Type of tablespace this file belongs to:

  • SHARED: For shared tablespace

  • LOCAL_FOR_RIM: Local temporary tablespace for RIM (read-only) instances

  • LOCAL_FOR_ALL: Local temporary tablespace for all instance types

INST_ID

NUMBER

Instance ID of the instance to which the temp file belongs. This column has a NULL value for temp files that belong to shared tablespaces.