方法一:
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> 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
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
转自:http://blog.itpub.net/7351078/viewspace-650630/