Delete a resource management plan

You can use the DELETE_PLAN subprogram in the DBMS_RESOURCE_MANAGER package to delete an unused resource management plan.

Prerequisites

The target resource management plan already exists.

Considerations

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

Procedure

1. Log in to a MySQL tenant of the cluster using the administrator.

2. Call the DELETE_PLAN subprogram in the DBMS_RESOURCE_MANAGER package to delete the resource management plan.

   obclient [test]> CALL DBMS_RESOURCE_MANAGER.DELETE_PLAN(
   PLAN => 'daytime'
   );
   

   Here, PLAN specifies the resource management plan.

3. Query the oceanbase.DBA_RSRC_PLANS view to verify whether the resource management plan has been deleted.

   +---------+------+----------+-----------------------------------+
   | PLAN_ID | PLAN | SUB_PLAN | COMMENTS                          |
   +---------+------+----------+-----------------------------------+
   |    NULL | DAY  | NULL     | This resource management plan is intended for transaction processing.             |
   +---------+------+----------+-----------------------------------+
   1 row in set
   

   For more information about the oceanbase.DBA_RSRC_PLANS view, see oceanbase.DBA_RSRC_PLANS.

References

DELETE_PLAN