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', 12, 'Archive Manager', 13, 'Others'),
  FILETYPE_KSFDSTCMP,                      -- FILETYPE_ID NUMBER
  decode(                                  -- FILETYPE_NAME VARCHAR2(28)
    FILETYPE_KSFDSTCMP, 1,'Control File', 2, 'Data File', 3, 'Log File', 4,'Archive Log', 6, 'Temp File', 9,'Data File Backup', 10,'Data File Incremental Backup', 11,'Archive Log Backup', 12, 'Data File Copy', 17,'Flashback Log', 18,'Data Pump Dump File', 'Other'),
  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
WHERE
  SBRDATA_KSFDSTCMP <> 0 OR A_SBRDATA_KSFDSTCMP <> 0 OR SBWDATA_KSFDSTCMP <> 0 OR A_SBWDATA_KSFDSTCMP <> 0 OR MBRDATA_KSFDSTCMP <> 0 OR A_MBRDATA_KSFDSTCMP <> 0 OR MBWDATA_KSFDSTCMP <> 0 OR A_MBWDATA_KSFDSTCMP <> 0 OR SBRREQS_KSFDSTCMP <> 0 OR A_SBRREQS_KSFDSTCMP <> 0 OR SBWREQS_KSFDSTCMP <> 0 OR A_SBWREQS_KSFDSTCMP <> 0 OR MBRREQS_KSFDSTCMP <> 0 OR A_MBRREQS_KSFDSTCMP <> 0 OR MBWREQS_KSFDSTCMP <> 0 OR A_MBWREQS_KSFDSTCMP <> 0 OR WREQS_KSFDSTCMP <> 0 OR A_WREQS_KSFDSTCMP <> 0 OR WTIME_KSFDSTCMP <> 0 OR A_WTIME_KSFDSTCMP <> 0
GROUP BY
  inst_id,
  COMPONENT_ID_KSFDSTCMP,
  FILETYPE_KSFDSTCMP
ORDER BY
  inst_id,
  COMPONENT_ID_KSFDSTCMP