User Tools

Site Tools


oracle

This is an old revision of the document!


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;
oracle.1345031402.txt.gz · Last modified: 2012/08/15 11:50 by root