select * from v$datafiles;
select * from v$controlfiles;
select * from v$logfile;
select * from v$archive;