V$RSRC_CONSUMER_GROUP

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

Column	Datatype	Description
`ID`	`NUMBER`	The consumer group object ID. A unique number, consistent across database shutdowns and startups.
`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 that sessions in the consumer group had to yield CPU to other sessions because of quantum expiration
`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
`ACTIVE_SESSION_LIMIT_HIT`	`NUMBER`	Number of times that sessions in the consumer group were queued because the consumer group reached its active session limit
`UNDO_LIMIT_HIT`	`NUMBER`	Number of times that queries in the consumer group were cancelled because the consumer group reached its `UNDO_POOL` limit
`SESSION_SWITCHES_IN`	`NUMBER`	Number of times that sessions switched into the consumer group. This does not include the number of times a session started in the consumer group (this is displayed by the `REQUESTS` column).
`SESSION_SWITCHES_OUT`	`NUMBER`	Number of times that sessions switched out of the consumer group to a different consumer group
`SQL_CANCELED`	`NUMBER`	Number of times that SQL queries running in the consumer group were aborted because they exceeded the resource manager plan's `SWITCH_TIME` limit and `CANCEL_SQL` was specified as the resource manager plan's `SWITCH_GROUP`
`ACTIVE_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions running in the consumer group were terminated because they exceeded the resource manager plan's `SWITCH_TIME` limit and `KILL_SESSION` was specified as the resource manager plan's `SWITCH_GROUP`
`IDLE_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions in the consumer group were killed because they were idle for too long (reached `MAX_IDLE_TIME`)
`IDLE_BLKR_SESSIONS_KILLED`	`NUMBER`	Number of times that sessions in the consumer group were killed because they were idle too long (reached `MAX_IDLE_BLOCKER_TIME`) and were blocking other sessions
`QUEUED_TIME`	`NUMBER`	Total amount of time that sessions in the consumer group have spent in the QUEUED state because of the active session limit
`QUEUE_TIME_OUTS`	`NUMBER`	Number of times that requests from sessions in the consumer group timed out because they were queued for too long (reached `QUEUEING_P1`)