home - keyword index

Table: DBA_TEMP_FILES

Information about database temp files

Column Name Description
AUTOEXTENSIBLE Autoextensible indicator: "YES" or "NO"
BLOCKS Size of the file in ORACLE blocks
BYTES Size of the file in bytes
FILE_ID ID of the database temp file
FILE_NAME Name of the database temp file
INCREMENT_BY Default increment for autoextension
MAXBLOCKS Maximum size of the file in ORACLE blocks
MAXBYTES Maximum size of the file in bytes
RELATIVE_FNO Tablespace-relative file number
STATUS File status: "AVAILABLE"
TABLESPACE_NAME Name of the tablespace to which the file belongs
USER_BLOCKS Size of the useful portion of file in ORACLE blocks
USER_BYTES Size of the useful portion of file in bytes

home - keyword index

Comment on this page: