This shows you the differences between two versions of the page.
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; |