GV$JAVAPOOL 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