GV$SERVICE_STATS definition in Oracle Database 11.2
GV$SERVICE_STATS

select
  s.inst_id,                               -- INST_ID NUMBER
  s.svchsh,                                -- SERVICE_NAME_HASH NUMBER
  s.svcnam,                                -- SERVICE_NAME VARCHAR2(64)
  m.extid,                                 -- STAT_ID NUMBER
  m.sname,                                 -- STAT_NAME VARCHAR2(64)
  s.kewsval                                -- VALUE NUMBER
from
  x$kewssvcv s,
  x$kewssmap m
where
  s.kewsoff = m.offst and m.aggid = 3

home |  up