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
Related examples in the same category