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-compatible 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
   

   For more information about the DBA_RSRC_CONSUMER_GROUPS view, see DBA_RSRC_CONSUMER_GROUPS.

References

DELETE_CONSUMER_GROUP