SELECT
  m.inst_id,                               -- INST_ID NUMBER
  m.begtime,                               -- BEGIN_TIME DATE
  m.endtime,                               -- END_TIME DATE
  m.intsize_csec,                          -- INTSIZE_CSEC NUMBER
  m.sequence#,                             -- SEQUENCE# NUMBER
  c.consumer_group_id_kgskscs,             -- CONSUMER_GROUP_ID NUMBER
  c.name_kgskscs,                          -- CONSUMER_GROUP_NAME VARCHAR2(30)
  m.cpu_consumed_time,                     -- CPU_CONSUMED_TIME NUMBER
  m.cpu_wait_time,                         -- CPU_WAIT_TIME NUMBER
  decode(                                  -- CPU_DECISIONS NUMBER
    m.total_cpu_decisions, 0, 0, floor((100*m.cpu_decisions_present)/ m.total_cpu_decisions)),
  decode(                                  -- CPU_DECISIONS_EXCLUSIVE NUMBER
    m.total_cpu_decisions, 0, 0, floor((100*m.cpu_decisions_alone) / m.total_cpu_decisions)),
  decode(                                  -- CPU_DECISIONS_WON NUMBER
    t.total_cpu_runs, 0, 0, floor((100 * m.cpu_runs) / t.total_cpu_runs)),
  m.io_requests,                           -- IO_REQUESTS NUMBER
  m.io_megabytes                           -- IO_MEGABYTES NUMBER
FROM
  x$kewmrmgmv m,
  x$kskplw p,
  x$kgskscs c,
  (
  SELECT
    begtime,
    sum(cpu_runs) as total_cpu_runs
  FROM
    x$kewmrmgmv
  GROUP BY
    begtime) t
WHERE
  flag1 = 1 AND m.sequence# = p.seq_kskplw AND p.end_tm_kskplw is null AND p.seq_kskplw = c.seq_kgskscs AND t.begtime = m.begtime AND m.consumer_group_id = c.num_kgskscs