eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:

PUBLIC: CDB_TEMP_FILES