V$SERVICEMETRIC definition in Oracle Database 11.2
V$SERVICEMETRIC

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
  goodness,                                -- GOODNESS NUMBER
  delta,                                   -- DELTA NUMBER
  flags                                    -- FLAGS NUMBER
FROM
  gv$servicemetric
WHERE
  inst_id = USERENV('INSTANCE')

home |  up