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

home |  up  |  mailbox