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 an Oracle 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 [SYS]> delimiter //
   
   obclient [SYS]> BEGIN DBMS_RESOURCE_MANAGER.DELETE_PLAN(
   PLAN => 'plan_a'
   );
   END ;//
   
   obclient [SYS]> delimiter ;
   

   Here, PLAN specifies the resource management plan.

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

   obclient [SYS]> SELECT PLAN_ID, PLAN, SUB_PLAN, COMMENTS FROM DBA_RSRC_PLANS;
   +---------+--------+----------+----------+
   | PLAN_ID | PLAN   | SUB_PLAN | COMMENTS |
   +---------+--------+----------+----------+
   |    NULL | PLAN_B | NULL     | NULL     |
   +---------+--------+----------+----------+
   1 row in set
   

   For more information about the DBA_RSRC_PLANS view, see DBA_RSRC_PLANS.

References

DELETE_PLAN