GV$SERV_MOD_ACT_STATS definition in Oracle 10g / www.oracledba.ru
GV$SERV_MOD_ACT_STATS
select
sma.inst_id, -- INST_ID NUMBER
'SERVICE_MODULE_ACTION', -- AGGREGATION_TYPE VARCHAR2(21)
sma.srvnam, -- SERVICE_NAME VARCHAR2(64)
sma.modnam, -- MODULE VARCHAR2(49)
sma.actnam, -- ACTION VARCHAR2(33)
m.extid, -- STAT_ID NUMBER
m.sname, -- STAT_NAME VARCHAR2(64)
sma.statval -- VALUE NUMBER
from
x$kewesmas sma,
x$kewssmap m
where
sma.statpos = m.offst and m.aggid = 3
union all
select
sm.inst_id, -- INST_ID NUMBER
'SERVICE_MODULE', -- AGGREGATION_TYPE VARCHAR2(21)
sm.srvnam, -- SERVICE_NAME VARCHAR2(64)
sm.modnam, -- MODULE VARCHAR2(49)
NULL, -- ACTION VARCHAR2(33)
m.extid, -- STAT_ID NUMBER
m.sname, -- STAT_NAME VARCHAR2(64)
sm.statval -- VALUE NUMBER
from
x$kewesms sm,
x$kewssmap m
where
sm.statpos = m.offst and m.aggid = 5