-----begin

方法一：
SQL> desc v$instance
Name                                      Null?    Type
------------------------------ ------- ----------------
INSTANCE_NUMBER                            NUMBER
INSTANCE_NAME                               VARCHAR2(16)
HOST_NAME                                     VARCHAR2(64)
VERSION                                          VARCHAR2(17)
STARTUP_TIME                                 DATE
STATUS                                           VARCHAR2(12)
PARALLEL                                         VARCHAR2(3)
THREAD#                                         NUMBER
ARCHIVER                                        VARCHAR2(7)
LOG_SWITCH_WAIT                           VARCHAR2(15)
LOGINS                                            VARCHAR2(10)
SHUTDOWN_PENDING                         VARCHAR2(3)
DATABASE_STATUS                           VARCHAR2(17)
INSTANCE_ROLE                                VARCHAR2(18)
ACTIVE_STATE                                 VARCHAR2(9)
BLOCKED                                          VARCHAR2(3)

SQL> select instance_name from v$instance;

INSTANCE_NAME
----------------
wilson

方法二：
SQL> select * from global_name;

GLOBAL_NAME
--------------------------------------------------------------------------------
WILSON

方法三：
SQL> show parameter instance_name

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string wilson

方法四：
[oracle@oracle11g ~]$ echo $oracle_sid

wilson

方法五：
SQL> !ps -ef | grep ora
oracle 5427 1 0 20:14 ? 00:00:01 ora_pmon_wilson
oracle 5429 1 0 20:14 ? 00:00:00 ora_vktm_wilson

----end

ITPub博客

oracle 查看当前启动的 Instance Name

最新文章