Oracle PL/SQL/System Tables Views/dba rsrc consumer groups

Listing the Resource Consumer Groups

 
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