SELECT
  inst_id,                                 -- INST_ID NUMBER
  COMPONENT_ID_KSFDSTCMP,                  -- FUNCTION_ID NUMBER
  decode(                                  -- FUNCTION_NAME VARCHAR2(18)
    COMPONENT_ID_KSFDSTCMP, 0, 'RMAN', 1, 'DBWR', 2, 'LGWR', 3, 'ARCH', 4, 'XDB', 5, 'Streams AQ', 6, 'Data Pump', 7, 'Recovery', 8, 'Buffer Cache Reads', 9, 'Direct Reads', 10, 'Direct Writes', 11, 'Smart Scan', 12, 'Archive Manager', 13, 'Others'),
  sum(                                     -- SMALL_READ_MEGABYTES NUMBER
    round((SBRDATA_KSFDSTCMP + A_SBRDATA_KSFDSTCMP) / 2048)),
  sum(                                     -- SMALL_WRITE_MEGABYTES NUMBER
    round((SBWDATA_KSFDSTCMP + A_SBWDATA_KSFDSTCMP) / 2048)),
  sum(                                     -- LARGE_READ_MEGABYTES NUMBER
    round((MBRDATA_KSFDSTCMP + A_MBRDATA_KSFDSTCMP) / 2048)),
  sum(                                     -- LARGE_WRITE_MEGABYTES NUMBER
    round((MBWDATA_KSFDSTCMP + A_MBWDATA_KSFDSTCMP) / 2048)),
  sum(                                     -- SMALL_READ_REQS NUMBER
    SBRREQS_KSFDSTCMP + A_SBRREQS_KSFDSTCMP),
  sum(                                     -- SMALL_WRITE_REQS NUMBER
    SBWREQS_KSFDSTCMP + A_SBWREQS_KSFDSTCMP),
  sum(                                     -- LARGE_READ_REQS NUMBER
    MBRREQS_KSFDSTCMP + A_MBRREQS_KSFDSTCMP),
  sum(                                     -- LARGE_WRITE_REQS NUMBER
    MBWREQS_KSFDSTCMP + A_MBWREQS_KSFDSTCMP),
  sum(                                     -- NUMBER_OF_WAITS NUMBER
    WREQS_KSFDSTCMP + A_WREQS_KSFDSTCMP),
  sum(                                     -- WAIT_TIME NUMBER
    WTIME_KSFDSTCMP + A_WTIME_KSFDSTCMP) 
FROM
  X$KSFDSTCMP
GROUP BY
  inst_id,
  COMPONENT_ID_KSFDSTCMP