DBA_RSRC_CONSUMER_GROUPS displays information about all resource consumer groups in the database.

Column Datatype NULL Description
CONSUMER_GROUP VARCHAR2(30)   Name of the consumer group
CPU_METHOD VARCHAR2(30)   CPU resource allocation method for the consumer group
COMMENTS VARCHAR2(2000)   Text comment on the consumer group
STATUS VARCHAR2(30)   PENDING, if consumer group is part of the pending area; NULL otherwise.
MANDATORY VARCHAR2(3)   Indicates whether the consumer group is mandatory (YES) or not (NO)