CREATE_PLAN_DIRECTIVE

The CREATE_PLAN_DIRECTIVE procedure is used to create a resource plan directive.

Syntax

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE (
    PLAN                      IN VARCHAR2,
    GROUP_OR_SUBPLAN          IN VARCHAR2,
    COMMENT                   IN VARCHAR2 DEFAULT'',
    MGMT_P1                   IN NUMBER   DEFAULT 100,
    UTILIZATION_LIMIT         IN NUMBER   DEFAULT 100,
    MIN_IOPS                  IN NUMBER   DEFAULT 0,
    MAX_IOPS                  IN NUMBER   DEFAULT 100,
    WEIGHT_IOPS               IN NUMBER   DEFAULT 0,
    MAX_NET_BANDWIDTH         IN INT DEFAULT 100,
    NET_BANDWIDTH_WEIGHT      IN INT DEFAULT 0);

Parameters

Examples

• Assign group1 to the DAY resource plan and specify the resource plan command for CPU resources in the resource group.

  obclient [SYS]> delimiter //
  

  obclient> BEGIN DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
      PLAN=>'DAY',
      GROUP_OR_SUBPLAN=>'group1',
      mgmt_p1=>80,
      utilization_limit=>100);
      END; //
  

  obclient [SYS]> delimiter ;
  

• You can use the ASSOCIATE_RESOURCE_PLAN procedure to bind the plan_a resource plan to the big_group resource group and specify resource plan instructions for CPU, IOPS, and network bandwidth in the resource group.

  obclient [SYS]> delimiter //
  

      obclient [SYS]> BEGIN DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE(
      PLAN => 'plan_a',
      GROUP_OR_SUBPLAN => 'big_group',
      COMMENT  => 'TP priority',
      UTILIZATION_LIMIT =>60,
      MIN_IOPS => 20,
      MAX_IOPS => 100,
      WEIGHT_IOPS => 20,
      MAX_NET_BANDWIDTH => 50,
      NET_BANDWIDTH_WEIGHT =>50);
      END; //
  

  obclient [SYS]> delimiter ;
  

References

For more information about how to configure resource isolation, see Configure resource isolation in a tenant.