GV$REQDIST select inst_id, -- INST_ID NUMBER kmmrdbuc, -- BUCKET NUMBER sum (kmmrdcnt) -- COUNT NUMBER from x$kmmrd where kmmrdpro!=hextoraw ('00') group by inst_id, kmmrdbuc