DBA_RSRC_CONSUMER_GROUPS

all the resource consumer groups

Columns
   ___________________________
 
   CONSUMER_GROUP
      consumer group name
   CPU_METHOD
      CPU resource allocation method for the consumer group
   COMMENTS
      Text comment on the consumer group
   STATUS
      PENDING if it is part of the pending area,ACTIVE otherwise
   MANDATORY
      Whether the consumer group is mandatory

Related:

DBA_RSRC_GROUP_MAPPINGS