Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

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