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

VIEW: SYS.CDB_TEMP_FILES

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

Information about database temp files in all containers

[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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_TEMP_FILES;

Dependencies

[top of page]

SYS.CDB_TEMP_FILES does not reference any database object

SYS.CDB_TEMP_FILES is referenced by following:

SchemaPUBLIC
SynonymCDB_TEMP_FILES