Update a resource management plan config

You can use the UPDATE_PLAN_DIRECTIVE subprogram in the DBMS_RESOURCE_MANAGER package to update a resource management plan config. The content that can be updated includes the resource management plan, the bound resource group, the CPU resources available for the resource group, and the limit on the CPU resources available for the resource group.

Prerequisites

If you want to change the original resource management plan or resource group, make sure that you have created a new one. For the steps to create a resource management plan or resource group, see Configure user-level resource isolation.

Procedure

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

2. Call the UPDATE_PLAN_DIRECTIVE subprogram in the DBMS_RESOURCE_MANAGER package to update the resource management plan config.

   obclient [SYS]> delimiter //
   
   obclient [SYS]> BEGIN DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
   PLAN => 'plan_a',
   GROUP_OR_SUBPLAN => 'big_group',
   NEW_COMMENT => 'new'
   NEW_MGMT_P1 => 40,
   NEW_UTILIZATION_LIMIT => 60,
   NEW_MIN_IOPS => 20,
   NEW_MAX_IOPS  => 100,
   NEW_WEIGHT_IOPS  => 10);
   END ;//
   
   obclient [SYS]> delimiter ;
   

   where

   • PLAN: Indicates the name of the new resource management plan.

   • GROUP_OR_SUBPLAN: Indicates the name of the new resource group.

   • NEW_COMMENT: Indicates the new comments on the resource management plan config.

   • NEW_MGMT_P1: Indicates the new percentage of CPU resources available for the resource group when the system runs at full load.

   • NEW_UTILIZATION_LIMIT: Indicates the new upper limit on the CPU resources available for the resource group.

   • NEW_MIN_IOPS: Indicates the new IOPS resources reserved for the resource group in the case of I/O resource contention. The sum of NEW_MIN_IOPS values of all resource groups cannot exceed 100.

   • NEW_MAX_IOPS: Indicates the new maximum IOPS resources available for the resource group. The sum of NEW_MAX_IOPS values of all resource groups can exceed 100.

   • NEW_WEIGHT_IOPS: Indicates the new weight for IOPS resources. The sum of NEW_WEIGHT_IOPS values of all resource groups can exceed 100.

3. Query the DBA_RSRC_PLAN_DIRECTIVES or DBA_OB_RSRC_IO_DIRECTIVES view to verify whether the resource management plan config has been updated.

   obclient [SYS]> SELECT PLAN, GROUP_OR_SUBPLAN, MGMT_P1, UTILIZATION_LIMIT FROM DBA_RSRC_PLAN_DIRECTIVES;
   +--------+------------------+---------+-------------------+
   | PLAN   | GROUP_OR_SUBPLAN | MGMT_P1 | UTILIZATION_LIMIT |
   +--------+------------------+---------+-------------------+
   | PLAN_A | BIG_GROUP        |      40 |                60 |
   | PLAN_A | SMALL_GROUP      |      40 |                70 |
   +--------+------------------+---------+-------------------+
   2 rows in set
   
   obclient [SYS]> SELECT * FROM DBA_OB_RSRC_IO_DIRECTIVES;
   

   For more information about the DBA_RSRC_PLAN_DIRECTIVES view, see DBA_RSRC_PLAN_DIRECTIVES.

   For more information about the DBA_OB_RSRC_IO_DIRECTIVES view, see DBA_OB_RSRC_IO_DIRECTIVES.

References

UPDATE_PLAN_DIRECTIVE