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 sessions in the consumer group had to yield the CPU

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