V$WLM_PCMETRIC definition in Oracle Database 11.2
V$WLM_PCMETRIC

SELECT
  begin_time,                              -- BEGIN_TIME DATE
  end_time,                                -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  pc_name_hash,                            -- PC_NAME_HASH NUMBER
  pc_name,                                 -- PC_NAME VARCHAR2(32)
  callspersec,                             -- CALLSPERSEC NUMBER
  errcallspersec,                          -- ERRCALLSPERSEC NUMBER
  responsetimepercall,                     -- RESPONSETIMEPERCALL BINARY_DOUBLE
  cpupercall,                              -- CPUPERCALL BINARY_DOUBLE
  cpuwaitpercall,                          -- CPUWAITPERCALL BINARY_DOUBLE
  iopercall,                               -- IOPERCALL BINARY_DOUBLE
  iowaitpercall,                           -- IOWAITPERCALL BINARY_DOUBLE
  gcpercall,                               -- GCPERCALL BINARY_DOUBLE
  gcwaitpercall,                           -- GCWAITPERCALL BINARY_DOUBLE
  niwaitpercall,                           -- NIWAITPERCALL BINARY_DOUBLE
  schwaitpercall                           -- SCHWAITPERCALL BINARY_DOUBLE
FROM
  gv$wlm_pcmetric
WHERE
  inst_id = USERENV('INSTANCE')

home |  up