Table of Contents

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;