GV$SERVICEMETRIC

SELECT
sm.inst_id,              -- INST_ID NUMBER
begtime,                 -- BEGIN_TIME DATE
endtime,                 -- END_TIME DATE
intsize_csec,            -- INTSIZE_CSEC NUMBER
groupid,                 -- GROUP_ID NUMBER
sv.kswsastabnmh,         -- SERVICE_NAME_HASH NUMBER
sv.kswsastabnm,          -- SERVICE_NAME VARCHAR2(64)
ctmhash,                 -- CTMHASH NUMBER
elapsedpercall,          -- ELAPSEDPERCALL NUMBER
cpupercall,              -- CPUPERCALL NUMBER
dbtimepercall,           -- DBTIMEPERCALL NUMBER
callspersec,             -- CALLSPERSEC NUMBER
dbtimepersec,            -- DBTIMEPERSEC NUMBER
goodness,                -- GOODNESS NUMBER
delta,                   -- DELTA NUMBER
flags                    -- FLAGS NUMBER
FROM
x$kewmsvcmv sm,
x$kswsastab sv 
WHERE
flag1 = 1 AND sm.svcid = sv.kswsastabsi
home |  up  |  mailbox