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>