select file#, status, enabled, name from v$datafile; select * from v$controlfile; select * from v$logfile;