GV$SESSTAT definition in Oracle Database 11.2
GV$SESSTAT

select
  inst_id,                                 -- INST_ID NUMBER
  ksusenum,                                -- SID NUMBER
  ksusestn,                                -- STATISTIC# NUMBER
  ksusestv                                 -- VALUE NUMBER
from
  x$ksusesta
where
  bitand(ksspaflg,1)!=0 and bitand(ksuseflg,1)!=0 and ksusestn<(
  select
    ksusgstl
  from
    x$ksusgif)

home |  up