How to: get Oracle database files location via PL/SQL query

You may use following query to get names and locations of database files:

\n\n

SELECT file_name,tablespace_name,bytes,blocks

FROM dba_data_files

ORDER BY tablespace_name,file_name

Example of output you get: