GV$SESS_TIME_MODEL
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)

home |  up  |  mailbox