SELECT
  inst_id,                                 -- INST_ID NUMBER
  begtime,                                 -- BEGIN_TIME DATE
  endtime,                                 -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  sessid,                                  -- SESSION_ID NUMBER
  sernum,                                  -- SERIAL_NUM NUMBER
  cpu,                                     -- CPU NUMBER
  phyrds,                                  -- PHYSICAL_READS NUMBER
  logrds,                                  -- LOGICAL_READS NUMBER
  pga_memory,                              -- PGA_MEMORY NUMBER
  hard_parses,                             -- HARD_PARSES NUMBER
  soft_parses,                             -- SOFT_PARSES NUMBER
  phyrds_pct,                              -- PHYSICAL_READ_PCT NUMBER
  logrds_pct                               -- LOGICAL_READ_PCT NUMBER
FROM
  x$kewmsemv
WHERE
  flag1 = 1