Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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.
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).