-- Name: show_dba_data_files.sql
-- 
-- Description: Data files - Display data files of the database
--
-- Usage: @show_dba_data_files
--
column file_name format a30 word_wrapped
column tablespace_name format a20 word_wrapped
column member format a30 word_wrapped
column name format a30 word_wrapped

select * from dba_data_files order by 1;
--select * from v$logfile order by 1;
--select * from v$controlfile order by 1;