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