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(15)
    ksuxslsw,0,NULL,2,'ARCHIVE LOG',3,'CLEAR LOG',4,'CHECKPOINT', 5,'REDO GENERATION'),
  decode(                                  -- LOGINS VARCHAR2(10)
    ksuxsdba,0,'ALLOWED','RESTRICTED'),
  decode(ksuxsshp,0,'NO','YES'),           -- SHUTDOWN_PENDING VARCHAR2(3)
  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'),
  decode(                                  -- BLOCKED VARCHAR2(3)
    bitand(ksuxsdst, 1), 0, 'NO', 1, 'YES', 'NO') 
from
  x$ksuxsinst ks,
  x$kvit kv,
  x$quiesce qu
where
  kvittag = 'kcbwst'