Oracle查看当前实例

方法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