GV$SERVICEMETRIC_HISTORY

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
FROM
x$kewmsvcmv sm,
x$kswsastab sv 
WHERE
sm.svcid = sv.kswsastabsi
home |  up  |  mailbox