V$RSRCMGRMETRIC

V$RSRCMGRMETRIC displays information about resources consumed and wait times per consumer group.

Column Datatype Description
BEGIN_TIME DATE Begin time for the metric value
END_TIME DATE End time for the metric value
INTSIZE_CSEC NUMBER Size of the time period
SEQUENCE# NUMBER A sequential counter that uniquely describes the V$RSRC_PLAN_HISTORY entry to which these consumer group statistics apply. When the instance is restarted, this value is reset to zero.
CONSUMER_GROUP_ID NUMBER Consumer group object ID (a unique number, consistent across database shutdowns and startups)
CONSUMER_GROUP_NAME VARCHAR2(30) Name of the consumer group
CPU_CONSUMED_TIME NUMBER Cumulative amount of CPU time consumed by all sessions in the consumer group
CPU_WAIT_TIME NUMBER Cumulative amount of time that sessions waited for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on.
CPU_DECISIONS NUMBER Percentage of CPU decisions for which the consumer group was present
CPU_DECISIONS_EXCLUSIVE NUMBER Percentage of the CPU decisions for which the consumer group was present and was the only consumer group present
CPU_DECISIONS_WON NUMBER Percentage of the CPU decisions that the consumer group won
IO_REQUESTS NUMBER I/O requests
IO_MEGABYTES NUMBER I/O megabytes