Dynamic Performance (V$) Views, 132 of 179

V$RSRC_CONSUMER_GROUP

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

See Also:

Oracle8i Administrator's Guide for information on resource groups.

Oracle8i Supplied PL/SQL Packages 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
`SESSIONS_QUEUED`	`NUMBER`	Reserved for future use.