V$RSRC_CONSUMER_GROUP

V$RSRC_CONSUMER_GROUP

This view displays data related to currently active resource consumer groups.

Column	Datatype	Description
`NAME`	`VARCHAR2(32)`	Name of the consumer group
`ACTIVE_SESSIONS`	`NUMBER`	Number of currently active sessions in the consumer group
`EXECUTION_WAITERS`	`NUMBER`	Number of currently active sessions waiting for an execution time slice in which they will be able to use CPU.
`REQUESTS`	`NUMBER`	Cumulative number of requests that were executed in the consumer group
`CPU_WAIT_TIME`	`NUMBER`	Cumulative amount of time that sessions waited for CPU
`CPU_WAITS`	`NUMBER`	Cumulative number of times all sessions in the consumer group had to wait for CPU
`CONSUMED_CPU_TIME`	`NUMBER`	Cumulative amount of CPU time consumed by all sessions in the consumer group
`YIELDS`	`NUMBER`	Cumulative number of times sessions in the consumer group had to yield the CPU
`QUEUE_LENGTH`	`NUMBER`	Number of sessions waiting in the queue
`CURRENT_UNDO_CONSUMPTION`	`NUMBER`	Current amount (in kilobytes) of undo consumed by the consumer group

See Also:

Oracle Database Administrator's Guide for information on resource groups
PL/SQL Packages and Types Reference for information on creating resource groups with the DBMS_RESOURCE_MANAGER package