select
  sma.inst_id,                             -- INST_ID NUMBER
  'SERVICE_MODULE_ACTION',                 -- AGGREGATION_TYPE VARCHAR2(21)
  sma.srvnam,                              -- SERVICE_NAME VARCHAR2(64)
  sma.modnam,                              -- MODULE VARCHAR2(49)
  sma.actnam,                              -- ACTION VARCHAR2(33)
  m.extid,                                 -- STAT_ID NUMBER
  m.sname,                                 -- STAT_NAME VARCHAR2(64)
  sma.statval                              -- VALUE NUMBER
from
  x$kewesmas sma,
  x$kewssmap m
where
  sma.statpos = m.offst and m.aggid = 4
union all
select
  sm.inst_id,                              -- INST_ID NUMBER
  'SERVICE_MODULE',                        -- AGGREGATION_TYPE VARCHAR2(21)
  sm.srvnam,                               -- SERVICE_NAME VARCHAR2(64)
  sm.modnam,                               -- MODULE VARCHAR2(49)
  NULL,                                    -- ACTION VARCHAR2(33)
  m.extid,                                 -- STAT_ID NUMBER
  m.sname,                                 -- STAT_NAME VARCHAR2(64)
  sm.statval                               -- VALUE NUMBER
from
  x$kewesms sm,
  x$kewssmap m
where
  sm.statpos = m.offst and m.aggid = 5