dba_temp_files
Name Null? Type
-------------------- -------- -------------
FILE_NAME VARCHAR2(257)
FILE_ID NUMBER
TABLESPACE_NAME NOT NULL VARCHAR2(30)
BYTES NUMBER
BLOCKS NUMBER
STATUS CHAR(9)
RELATIVE_FNO NUMBER
AUTOEXTENSIBLE VARCHAR2(3)
MAXBYTES NUMBER
MAXBLOCKS NUMBER
INCREMENT_BY NUMBER
USER_BYTES NUMBER
USER_BLOCKS NUMBER
Lists all temp files in the database. For example:
select tablespace_name
, file_name
, bytes
from dba_temp_files
/
TABLESPACE_NAME FILE_NAME BYTES
-------------------- ----------------------------- ----------
TEMP /u01/scr9/temp01.tdf 3145728000
Similar information is available in v$tempfile;
For more useful DBA queries click here.
| 