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, in milliseconds |
CPU_WAIT_TIME |
NUMBER |
Cumulative amount of time that sessions waited for CPU because of resource management, in milliseconds. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
NUM_CPUSFoot 1 |
NUMBER |
Number of CPUs that the Resource Manager is utilizing. If instance caging is enabled, then this column is equal to the value of the CPU_COUNT initialization parameter. If instance caging is not enabled, then this column is equal to the total number of CPUs in the system. |
RUNNING_SESSIONS_LIMITFootref 1 |
NUMBER |
Maximum number of sessions in the consumer group that can run simultaneously. The value of this column is set by the Resource Manager plan's MAX_UTILIZATION_LIMIT directive. |
AVG_RUNNING_SESSIONSFootref 1 |
NUMBER |
Average number of sessions in the consumer group that are currently running |
AVG_WAITING_SESSIONSFootref 1 |
NUMBER |
Average number of sessions in the consumer group that are waiting for CPU due to resource management |
CPU_UTILIZATION_LIMITFootref 1 |
NUMBER |
Maximum percentage of CPU that the consumer group can utilize at any time. The value of this column is set by the Resource Manager plan's MAX_UTILIZATION_LIMIT directive. If instance caging is enabled, then this value is derived using the CPU_COUNT initialization parameter. |
AVG_CPU_UTILIZATIONFootref 1 |
NUMBER |
Average percentage CPU consumed by the consumer group |
CPU_DECISIONS |
NUMBER |
Percentage of CPU decisions for which the consumer group was present. This column is deprecated. |
CPU_DECISIONS_EXCLUSIVE |
NUMBER |
Percentage of the CPU decisions for which the consumer group was present and was the only consumer group present. This column is deprecated. |
CPU_DECISIONS_WON |
NUMBER |
Percentage of the CPU decisions that the consumer group won. This column is deprecated. |
IO_REQUESTS |
NUMBER |
I/O requests |
IO_MEGABYTES |
NUMBER |
I/O megabytes |
Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).