oracle 实例信息查询
SQL> desc gv$instance;
Name Null? Type
INST_ID NUMBER
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)
set linesize 200
col INST_ID format 99
col INSTANCE_NUMBER format 99
col INSTANCE_NAME format a16
col HOST_NAME format a15
col VERSION format a11
col STARTUP_TIME format a12
col STATUS format a6
col PARALLEL format a5
col THREAD# format 99
col ARCHIVER format a10
col LOG_SWITCH_WAIT format a10
col LOGINS format a10
col SHUTDOWN_PENDING format a5
col DATABASE_STATUS format a15
col INSTANCE_ROLE format a18
col ACTIVE_STATE format a10
col BLOCKED format a5
select * from v$instance;
select * from gv$instance;