User Tools

Site Tools


oracle

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;
oracle.txt · Last modified: 2012/08/29 06:48 by root