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'

home |  up  |  mailbox