Oracle查看当前实例

2014-11-24 18:04:00 · 作者: · 浏览: 0

方法1


SQL> select name from v$database;


NAME
---------
JSSBOOK


方法2


SQL> SELECT host_name, instance_name, version FROM v$instance;


HOST_NAME
----------------------------------------------------------------
INSTANCE_NAME VERSION
---------------- -----------------
ZZH-PC
jssbook 11.2.0.1.0