Oracle: IDing database files

There are two oracle data dictionary tables that contain information on what files an oracle instance is using. The specific queries are as follows:

select tablespace_name, file_name

from dba_data_files

order by tablespace_name;



select member from v$logfile

order by member;