DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_TEMP_FILES

Object Details
Object Name: DBA_TEMP_FILES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Information about database temp files

[View Source]

Columns
Name Datatype Length Mandatory Comments
FILE_NAME VARCHAR2 (513)
Name of the database temp file
FILE_ID NUMBER

ID of the database temp file
TABLESPACE_NAME VARCHAR2 (30) Yes 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: "AVAILABLE"
RELATIVE_FNO NUMBER

Tablespace-relative file number
AUTOEXTENSIBLE VARCHAR2 (3)
Autoextensible indicator: "YES" or "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
USER_BYTES NUMBER

Size of the useful portion of file in bytes
USER_BLOCKS NUMBER

Size of the useful portion of file in ORACLE blocks
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FILE_NAME
,      FILE_ID
,      TABLESPACE_NAME
,      BYTES
,      BLOCKS
,      STATUS
,      RELATIVE_FNO
,      AUTOEXTENSIBLE
,      MAXBYTES
,      MAXBLOCKS
,      INCREMENT_BY
,      USER_BYTES
,      USER_BLOCKS
FROM SYS.DBA_TEMP_FILES;

Dependencies

[top of page]

SYS.DBA_TEMP_FILES references the following:

SchemaSYS
TableTS$
SYS.DBA_TEMP_FILES is referenced by following:

SchemaPUBLIC
SynonymDBA_TEMP_FILES
SchemaSYS
Package BodyDBMS_PREUP - show dependent code