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 ) |
See Also:
Oracle Database Administrator's Guide for information on resource groups
Oracle Database PL/SQL Packages and Types Reference for information on creating resource groups with the DBMS_RESOURCE_MANAGER
package