Static Data Dictionary Views, 219 of 452

DBA_RSRC_CONSUMER_GROUPS

DBA_RSRC_CONSUMER_GROUPS lists all resource consumer groups in the database.

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