ID |
NUMBER |
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 because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
CPU_WAITS |
NUMBER |
Cumulative number of times all sessions in the consumer group had to wait for CPU because of resource management. This does not include waits due to latch or enqueue contention, I/O waits, and so on. |
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 KB) 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 |
SWITCHES_IN_CPU_TIME |
NUMBER |
Number of switches into the consumer group because of the Resource Manager plan's SWITCH_TIME limit |
SWITCHES_OUT_CPU_TIME |
NUMBER |
Number of switches out of the consumer group because of the Resource Manager plan's SWITCH_TIME limit |
SWITCHES_IN_IO_MEGABYTES |
NUMBER |
Number of switches into the consumer group because of the Resource Manager plan's SWITCH_IO_MEGABYTES limit |
SWITCHES_OUT_IO_MEGABYTES |
NUMBER |
Number of switches out of the consumer group because of the Resource Manager plan's SWITCH_IO_MEGABYTES limit |
SWITCHES_IN_IO_REQUESTS |
NUMBER |
Number of switches into the consumer group because of the Resource Manager plan's SWITCH_IO_REQS limit |
SWITCHES_OUT_IO_REQUESTS |
NUMBER |
Number of switches out of the consumer group because of the Resource Manager plan's SWITCH_IO_REQS limit |
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) |
IO_SERVICE_TIME |
NUMBER |
Cumulative I/O wait time (in microseconds) |
IO_SERVICE_WAITS |
NUMBER |
Total number of wait requests |
SMALL_READ_MEGABYTES |
NUMBER |
Number of single block megabytes read |
SMALL_WRITE_MEGABYTES |
NUMBER |
Number of single block megabytes written |
LARGE_READ_MEGABYTES |
NUMBER |
Number of multiblock megabytes read |
LARGE_WRITE_MEGABYTES |
NUMBER |
Number of multiblock megabytes written |
SMALL_READ_REQUESTS |
NUMBER |
Number of single block read requests |
SMALL_WRITE_REQUESTS |
NUMBER |
Number of single block write requests |
LARGE_READ_REQUESTS |
NUMBER |
Number of multiblock read requests |
LARGE_WRITE_REQUESTS |
NUMBER |
Number of multiblock write requests |
