====== Oracle hints ======

===== Log into Oracle =====

  sqlplus '/ as sysdba'

===== Show control files =====

  select name from v$controlfile;
  
===== Show log files =====

  select member from v$logfile;
  
===== Show data files =====

  select file_name from dba_data_files order by file_name asc;

===== Show Oracle status =====

  select status from v$instance;
  select * from v$instance;
  
===== Show Oracle version =====

  select * from v$version;