User Tools

Site Tools


oracle

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

oracle [2011/12/21 11:12]
root created
oracle [2012/08/29 06:48] (current)
root
Line 17: Line 17:
   select file_name from dba_data_files order by file_name asc;   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.1324465943.txt.gz ยท Last modified: 2011/12/21 11:12 by root