Search notes:
Oracle: V$TEMPFILE
v$tempfile
returns a record for each
temp file
.
See also
dba_temp_files
v$datafile
Temporary tablespaces
Oracle Dynamic Performance Views
Index