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