SELECT
  sm.inst_id,                              -- INST_ID NUMBER
  begtime,                                 -- BEGIN_TIME DATE
  endtime,                                 -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  groupid,                                 -- GROUP_ID NUMBER
  sv.kswsastabnmh,                         -- SERVICE_NAME_HASH NUMBER
  sv.kswsastabnm,                          -- SERVICE_NAME VARCHAR2(64)
  ctmhash,                                 -- CTMHASH NUMBER
  elapsedpercall,                          -- ELAPSEDPERCALL NUMBER
  cpupercall,                              -- CPUPERCALL NUMBER
  dbtimepercall,                           -- DBTIMEPERCALL NUMBER
  callspersec,                             -- CALLSPERSEC NUMBER
  dbtimepersec,                            -- DBTIMEPERSEC NUMBER
  goodness,                                -- GOODNESS NUMBER
  delta,                                   -- DELTA NUMBER
  flags                                    -- FLAGS NUMBER
FROM
  x$kewmsvcmv sm,
  x$kswsastab sv
WHERE
  flag1 = 1 AND sm.svcid = sv.kswsastabsi