Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

V$RSRC_CONSUMER_GROUP

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

Column Datatype Description
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


See Also: