Table: DBA_RSRC_CONSUMER_GROUPS
all the resource consumer groups
| Column Name | Description |
|---|---|
| COMMENTS | Text comment on the consumer group |
| CONSUMER_GROUP | consumer group name |
| CPU_METHOD | CPU resource allocation method for the consumer group |
| MANDATORY | Whether the consumer group is mandatory |
| STATUS | PENDING if it is part of the pending area, ACTIVE otherwise |