GV$MYSTAT definition in Oracle Database 11.2
GV$MYSTAT

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

home |  up