select
  INST_ID,                                 -- INST_ID NUMBER
  KSUCPUSTATNAME,                          -- STAT_NAME VARCHAR2(64)
  decode(                                  -- VALUE NUMBER
    KSUCPUSTATID, 15, KSUCPUSTATVALUE/1024, KSUCPUSTATVALUE),
  KSUCPUSTATID,                            -- OSSTAT_ID NUMBER
  KSUCPUSTATCMT,                           -- COMMENTS VARCHAR2(64)
  decode(                                  -- CUMULATIVE VARCHAR2(3)
    bitand(KSUCPUSTATFLAGS,1),1,'YES','NO') 
from
  X$KSUCPUSTAT
union all
select
  INST_ID,                                 -- INST_ID NUMBER
  KSUVMSTATNAME,                           -- STAT_NAME VARCHAR2(64)
  KSUVMSTATVALUE,                          -- VALUE NUMBER
  KSUVMSTATID,                             -- OSSTAT_ID NUMBER
  KSUVMSTATCMT,                            -- COMMENTS VARCHAR2(64)
  decode(                                  -- CUMULATIVE VARCHAR2(3)
    bitand(KSUVMSTATFLAGS,1),1,'YES','NO') 
from
  X$KSUVMSTAT
union all
select
  INST_ID,                                 -- INST_ID NUMBER
  KSUNETSTATNAME,                          -- STAT_NAME VARCHAR2(64)
  KSUNETSTATVALUE,                         -- VALUE NUMBER
  KSUNETSTATID,                            -- OSSTAT_ID NUMBER
  KSUNETSTATCMT,                           -- COMMENTS VARCHAR2(64)
  decode(                                  -- CUMULATIVE VARCHAR2(3)
    bitand(KSUNETSTATFLAGS,1),1,'YES','NO') 
from
  X$KSUNETSTAT