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? (for Dba )
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? (for Dba )

Answer»

TEMPFILES, unlike NORMAL datafiles, are not LISTED in v$datafile or dba_data_files. Instead QUERY v$tempfile or 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: