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