Oracle PL/SQL/System Tables Views/dba rsrc consumer groups
Listing the Resource Consumer Groups
<source lang="sql">
SQL> SQL> SELECT consumer_group, status
2 FROM dba_rsrc_consumer_groups;
CONSUMER_GROUP STATUS
------------------------------
OTHER_GROUPS DEFAULT_CONSUMER_GROUP SYS_GROUP LOW_GROUP AUTO_TASK_CONSUMER_GROUP
</source>