Where Are My Tempfiles, I Don't See Them In V$datafile Or Dba_data_fi

1.	Where Are My Tempfiles, I Don't See Them In V$datafile Or Dba_data_file?
Answer» TEMPFILES, UNLIKE normal DATAFILES, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files: SELECT * FROM v$tempfile; SELECT * FROM dba_temp_files; Tempfiles, unlike normal datafiles, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files:

Where Are My Tempfiles, I Don't See Them In V$datafile Or Dba_data_file?

Answer»

TEMPFILES, UNLIKE normal DATAFILES, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files:

SELECT * FROM v$tempfile; SELECT * FROM dba_temp_files;

Tempfiles, unlike normal datafiles, are not listed in v$datafile or dba_data_files. Instead query v$tempfile or dba_temp_files: