V$RSRC_CONSUMER_GROUP

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

See Also: Oracle9i Database Administrator's Guide for information on resource groups Oracle9i Supplied PL/SQL Packages and Types Reference for information on creating resource groups with the DBMS_RESOURCE_MANAGER package

Column	Datatype	Description
NAME	VARCHAR2(32)	Name of the consumer group
ACTIVE_SESSIONS	NUMBER	Number of currently active sessions in this 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 this 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 this consumer group had to wait for CPU
CONSUMED_CPU_TIME	NUMBER	Cumulative amount of CPU time consumed by all sessions in this consumer group
YIELDS	NUMBER	Cumulative number of times sessions in this 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