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 |