SELECT
  m.inst_id,                               -- INST_ID NUMBER
  begtime,                                 -- BEGIN_TIME DATE
  endtime,                                 -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  kywmpctabhash,                           -- PC_NAME_HASH NUMBER
  kywmpctabsp,                             -- PC_NAME VARCHAR2(32)
  callspersec,                             -- CALLSPERSEC NUMBER
  0,                                       -- ERRCALLSPERSEC NUMBER
  cast(                                    -- RESPONSETIMEPERCALL BINARY_DOUBLE
    dbtimepercall as binary_double),
  cast(                                    -- CPUPERCALL BINARY_DOUBLE
    cpupercall as binary_double),
  cast(                                    -- CPUWAITPERCALL BINARY_DOUBLE
    cpuwaitpercall as binary_double),
  cast(                                    -- IOPERCALL BINARY_DOUBLE
    iopercall as binary_double),
  cast(                                    -- IOWAITPERCALL BINARY_DOUBLE
    iowpercall as binary_double),
  case                                     -- GCPERCALL BINARY_DOUBLE 
     when (callspersec = 0) 
     then cast(gccrpercall as binary_double) 
     else 0 end,
  cast(                                    -- GCWAITPERCALL BINARY_DOUBLE
    (gccrpercall + gccurpercall) as binary_double),
  cast(                                    -- NIWAITPERCALL BINARY_DOUBLE
    niwaitpercall as binary_double),
  cast(                                    -- SCHWAITPERCALL BINARY_DOUBLE
    schwaitpercall as binary_double) 
FROM
  x$kewmwpcmv m,
  x$kywmpctab p
WHERE
  m.pckey = p.kywmpctabhash