|
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 |
