DBA_TEMP_FILES
describes all temporary files (tempfiles) in the database.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Name of the database temp file |
|
|
|
File identifier number of the database temp file |
|
|
|
|
Name of the tablespace to which the file belongs |
|
|
Size of the file (in bytes) |
|
|
|
Size of the file (in Oracle blocks) |
|
|
|
File status:
|
|
|
|
Tablespace-relative file number |
|
|
|
Indicates whether the file is autoextensible ( |
|
|
|
maximum size of the file (in bytes) |
|
|
|
Maximum size of the file (in Oracle blocks) |
|
|
|
Default increment for autoextension (in Oracle blocks) |
|
|
|
Size of the useful portion of the file (in bytes) |
|
|
|
Size of the useful portion of the file (in Oracle blocks) |