V$SERVICEMETRIC_HISTORY definition in Oracle Database 11.2
V$SERVICEMETRIC_HISTORY

SELECT
  begin_time,                              -- BEGIN_TIME DATE
  end_time,                                -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  group_id,                                -- GROUP_ID NUMBER
  service_name_hash,                       -- SERVICE_NAME_HASH NUMBER
  service_name,                            -- SERVICE_NAME VARCHAR2(64)
  ctmhash,                                 -- CTMHASH NUMBER
  elapsedpercall,                          -- ELAPSEDPERCALL NUMBER
  cpupercall,                              -- CPUPERCALL NUMBER
  dbtimepercall,                           -- DBTIMEPERCALL NUMBER
  callspersec,                             -- CALLSPERSEC NUMBER
  dbtimepersec                             -- DBTIMEPERSEC NUMBER
FROM
  gv$servicemetric_history
WHERE
  inst_id = USERENV('INSTANCE')

home |  up