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; | ||