Delete a resource group

You can call the DELETE_CONSUMER_GROUP subprogram in the DBMS_RESOURCE_MANAGER package to delete an idle resource group.

Prerequisites

The resource group to be deleted exists.

Considerations

After a resource group is deleted, the plan directive associated with the resource group is also deleted.

Procedure

1. Log in to an Oracle tenant in the cluster as the administrator of the tenant.

2. Call the DELETE_CONSUMER_GROUP subprogram in the DBMS_RESOURCE_MANAGER package to delete the resource group.

   obclient [SYS]> delimiter //
   
   obclient [SYS]]> BEGIN DBMS_RESOURCE_MANAGER.DELETE_CONSUMER_GROUP(
   CONSUMER_GROUP => 'big_group' 
   );
   END ;//
   
   obclient [SYS]> delimiter ;
   

   Here, CONSUMER_GROUP specifies the name of the resource group to be deleted.

3. Query the DBA_RSRC_CONSUMER_GROUPS view to verify whether the resource group is deleted.

   obclient [SYS]> SELECT CONSUMER_GROUP_ID, CONSUMER_GROUP, COMMENTS FROM DBA_RSRC_CONSUMER_GROUPS;
   +-------------------+----------------+-----------------+
   | CONSUMER_GROUP_ID | CONSUMER_GROUP | COMMENTS        |
   +-------------------+----------------+-----------------+
   |                 4 | GROUP1         | Transaction processing group       |
   |                 0 | OTHER_GROUPS   | NULL            |
   |                 3 | SMALL_GROUP    | AP              |
   |                 1 | SYS_GROUP      | NULL            |
   +-------------------+----------------+-----------------+
   4 rows in set
   

References

DELETE_CONSUMER_GROUP