V$RSRCMGRMETRIC_HISTORY definition in Oracle Database 11.2
V$RSRCMGRMETRIC_HISTORY

SELECT
  begin_time,                              -- BEGIN_TIME DATE
  end_time,                                -- END_TIME DATE
  intsize_csec,                            -- INTSIZE_CSEC NUMBER
  sequence#,                               -- SEQUENCE# NUMBER
  consumer_group_id,                       -- CONSUMER_GROUP_ID NUMBER
  consumer_group_name,                     -- CONSUMER_GROUP_NAME VARCHAR2(30)
  cpu_consumed_time,                       -- CPU_CONSUMED_TIME NUMBER
  cpu_wait_time,                           -- CPU_WAIT_TIME NUMBER
  cpu_decisions,                           -- CPU_DECISIONS NUMBER
  cpu_decisions_exclusive,                 -- CPU_DECISIONS_EXCLUSIVE NUMBER
  cpu_decisions_won,                       -- CPU_DECISIONS_WON NUMBER
  io_requests,                             -- IO_REQUESTS NUMBER
  io_megabytes                             -- IO_MEGABYTES NUMBER
FROM
  gv$rsrcmgrmetric_history
WHERE
  inst_id = USERENV('INSTANCE')

home |  up