SELECT
  s.inst_id,                               -- INST_ID NUMBER
  s.pckey,                                 -- PC_NAME_HASH NUMBER
  p.kywmpctabsp,                           -- PC_NAME VARCHAR2(32)
  m.extid,                                 -- STAT_ID NUMBER
  m.sname,                                 -- STAT_NAME VARCHAR2(64)
  s.statval                                -- VALUE NUMBER
FROM
  x$kewepcs s,
  x$kewssmap m,
  x$kywmpctab p
WHERE
  s.pcspos = m.offst AND m.aggid = 7 AND s.pckey = p.kywmpctabhash