FILE_NAME |
VARCHAR2(513) |
|
Name of the database temp file |
FILE_ID |
NUMBER |
|
ID 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: 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 database 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 database blocks |