Saturday, 10 November 2012

Where are my TEMPFILES, I don't see them in V$DATAFILE or DBA_DATA_FILE? | SQL 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;

No comments: