GV$SESS_TIME_MODEL definition in Oracle Database 11.2
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