How to: get Oracle database files location via PL/SQL query Mikhail | December 12, 2013 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: