Delete a resource group

You can use the DELETE_CONSUMER_GROUP subprogram in the DBMS_RESOURCE_MANAGER package to delete an unused resource group.

Prerequisites

The target resource group already exists.

Considerations

Deleting a resource group will also delete the associated resource management plan config.

Procedure

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

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 resource group.

3. Query the DBA_RSRC_CONSUMER_GROUPS view to verify whether the resource group has been 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
   

   For more information about the DBA_RSRC_CONSUMER_GROUPS view, see DBA_RSRC_CONSUMER_GROUPS.

References

DELETE_CONSUMER_GROUP