select
  inst_id,                                 -- INST_ID NUMBER
  ksmchcom,                                -- CATEGORY VARCHAR2(16)
  sum(ksmchsiz)                            -- MEMUSED NUMBER
from
  x$ksmjch
group by
  inst_id,
  ksmchcom
order by
  ksmchcom