GV$INSTANCE definition in Oracle 9i / www.oracledba.ru
GV$INSTANCE
select
ks.inst_id, -- INST_ID NUMBER
ksuxsins, -- INSTANCE_NUMBER NUMBER
ksuxssid, -- INSTANCE_NAME VARCHAR2(16)
ksuxshst, -- HOST_NAME VARCHAR2(64)
ksuxsver, -- VERSION VARCHAR2(17)
ksuxstim, -- STARTUP_TIME DATE
decode -- STATUS VARCHAR2(12)
(ksuxssts, 0, 'STARTED', 1, 'MOUNTED', 2, 'OPEN', 3, 'OPEN MIGRATE', 'UNKNOWN'),
decode -- PARALLEL VARCHAR2(3)
(ksuxsshr, 0, 'NO', 1, 'YES', 2, NULL),
ksuxsthr, -- THREAD# NUMBER
decode -- ARCHIVER VARCHAR2(7)
(ksuxsarc, 0, 'STOPPED', 1, 'STARTED', 'FAILED'),
decode -- LOG_SWITCH_WAIT VARCHAR2(11)
(ksuxslsw, 0, NULL, 2, 'ARCHIVE LOG', 3, 'CLEAR LOG', 4, 'CHECKPOINT'),
decode -- LOGINS VARCHAR2(10)
(ksuxsdba, 0, 'ALLOWED', 'RESTRICTED'),
decode -- SHUTDOWN_PENDING VARCHAR2(3)
(ksuxsshp, 0, 'NO', 'YES'),
decode -- DATABASE_STATUS VARCHAR2(17)
(kvitval, 0, 'ACTIVE', 2147483647, 'SUSPENDED', 'INSTANCE RECOVERY'),
decode -- INSTANCE_ROLE VARCHAR2(18)
(ksuxsrol, 1, 'PRIMARY_INSTANCE', 2, 'SECONDARY_INSTANCE', 'UNKNOWN'),
decode -- ACTIVE_STATE VARCHAR2(9)
(qui_state, 0, 'NORMAL', 1, 'QUIESCING', 2, 'QUIESCED', 'UNKNOWN')
from
x$ksuxsinst ks,
x$kvit kv,
x$quiesce qu
where
kvittag = 'kcbwst'