SEQUENCE# |
NUMBER |
A sequential counter that uniquely describes the V$RSRC_PLAN_HISTORY entry to which these consumer group statistics apply. When the instance is restarted, this value is reset to zero. |
ID |
NUMBER |
The consumer group object ID. A unique number, consistent across database shutdowns and startups. |
NAME |
VARCHAR2(30) |
The consumer group name |
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 |
ACTIVE_SESS_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_SESS_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_SESS_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_SESS_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 ) |