UPDATE_PLAN_DIRECTIVE

The UPDATE_PLAN_DIRECTIVE procedure is used to update a resource plan directive.

Syntax

DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE (
    PLAN                             IN VARCHAR2,
    GROUP_OR_SUBPLAN                 IN VARCHAR2,
    NEW_COMMENT                      IN VARCHAR2 DEFAULT NULL,
    NEW_MGMT_P1                      IN INT   DEFAULT NULL,
    NEW_UTILIZATION_LIMIT            IN INT   DEFAULT NULL,
    NEW_MIN_IOPS                     IN INT   DEFAULT NULL,
    NEW_MAX_IOPS                     IN INT   DEFAULT NULL,
    NEW_WEIGHT_IOPS                  IN INT   DEFAULT NULL,
    NEW_MAX_NET_BANDWIDTH            IN INT   DEFAULT NULL,
    NEW_NET_BANDWIDTH_WEIGHT         IN INT   DEFAULT NULL);

Parameters

Considerations

If you do not specify parameters for the UPDATE_PLAN_DIRECTIVE procedure, the parameter values remain unchanged in the data dictionary.

To set any numeric parameter in a resource plan directive to zero or invalid, use the UPDATE_PLAN_DIRECTIVE procedure and set the parameter to -1.

Examples

• Update the comment of the plan directive for the resource group group1 bound to the resource plan DAY.

  obclient [SYS]> delimiter //
  

  obclient [SYS]> BEGIN DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE('DAY','group1','Intermediate-level group');
  END ;//
  

  obclient [SYS]> delimiter ;
  

• Update the resource plan content for the resource group big_group bound to the resource plan plan_a, including CPU, IOPS, and network bandwidth resources.

  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,
    NEW_MAX_NET_BANDWIDTH => 60,
    NEW_NET_BANDWIDTH_WEIGHT => 60);
    END ;//
  

  obclient [SYS]> delimiter ;
  

References

For more information about how to update a resource plan directive, see Update a resource plan directive.