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 |