FILE_NAME |
VARCHAR2(513) |
|
Name of the database temp file |
FILE_ID |
NUMBER |
|
File identifier number of the database temp file |
TABLESPACE_NAME |
VARCHAR2(30) |
NOT NULL |
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 |
CHAR(9) |
|
File status:
|
RELATIVE_FNO |
NUMBER |
|
Tablespace-relative file number |
AUTOEXTENSIBLE |
VARCHAR2(3) |
|
Indicates whether the file is autoextensible (YES) or not (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 the file (in bytes) |
USER_BLOCKS |
NUMBER |
|
Size of the useful portion of the file (in Oracle blocks) |
