Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? (for DBA
ORACLE Interview Questions and Answers (Part 1)
(Continued from previous question...)
86. Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? (for DBA
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;
(Continued on next question...)
Other Interview Questions
|