ORACLE: Archivos propios de una instancia.

select value from v$parameter where name = 'spfile';

select name from v$controlfile;

select member from v$logfile;

select name from v$archived_log where dest_id = 1;

select file_name from dba_temp_files;

select file_name from dba_data_files join dba_tablespaces using (tablespace_name) where contents = 'UNDO';

select file_name from dba_data_files join dba_tablespaces using (tablespace_name) where contents != 'UNDO';