select map.inst_id, -- INST_ID NUMBER sesv.ksusenum, -- SID NUMBER map.extid, -- STAT_ID NUMBER map.sname, -- STAT_NAME VARCHAR2(64) sesv.kewsval -- VALUE NUMBER from x$kewssmap map, x$kewssesv sesv where map.soffst = sesv.kewsnum and map.aggid = 1 and bitand(sesv.ksspaflg,1)!=0 and bitand(sesv.ksuseflg,1)!=0 and (map.stype = 2 or map.stype = 3)