DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_CONSUMER_GROUPS lists 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)		Status of the consumer group: PENDING if the group is part of the pending area, ACTIVE otherwise.
MANDATORY	VARCHAR2(3)		Whether the consumer group is mandatory (YES | NO)