DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN注意事项

最新推荐文章于 2011-10-09 09:13:06 发布

原创最新推荐文章于 2011-10-09 09:13:06 发布 · 212 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

Oracle & SQL

通过使用CREATE_SIMPLE_PLAN过程，可以快速创建适用于多种情况的简单资源计划。该过程允许您定义最多八个消费者组，并为每个组分配CPU资源百分比。计划采用EMPHASIS CPU分配策略，每个消费者组使用ROUND_ROBIN调度策略。

Creating a Simple Resource Plan
You can quickly create a simple resource plan that will be adequate for many situations using the CREATE_SIMPLE_PLAN procedure. This procedure enables you to create consumer groups and allocate resources to them by executing a single statement. Using this procedure, you are not required to invoke the procedures that are described in succeeding sections for creating a pending area, creating each consumer group individually, and specifying resource plan directives.

You can specify the following parameters for the CREATE_SIMPLE_PLAN procedure:

Parameter Description
SIMPLE_PLAN Name of the plan
CONSUMER_GROUP1 Consumer group name for first group
GROUP1_CPU CPU resource allocated to this group
CONSUMER_GROUP2 Consumer group name for second group
GROUP2_CPU CPU resource allocated to this group
CONSUMER_GROUP3 Consumer group name for third group
GROUP3_CPU CPU resource allocated to this group
CONSUMER_GROUP4 Consumer group name for fourth group
GROUP4_CPU CPU resource allocated to this group
CONSUMER_GROUP5 Consumer group name for fifth group
GROUP5_CPU CPU resource allocated to this group
CONSUMER_GROUP6 Consumer group name for sixth group
GROUP6_CPU CPU resource allocated to this group
CONSUMER_GROUP7 Consumer group name for seventh group
GROUP7_CPU CPU resource allocated to this group
CONSUMER_GROUP8 Consumer group name for eighth group
GROUP8_CPU CPU resource allocated to this group

Up to eight consumer groups can be specified using this procedure and the only plan directive that can be specified is for CPU. The plan uses the EMPHASIS CPU allocation policy and each consumer group uses the ROUND_ROBIN scheduling policy. [b]Each consumer group specified in the plan is allocated its CPU percentage at level 2[/b]. Also implicitly included in the plan are SYS_GROUP (a system-defined group that is the initial consumer group for the users SYS and SYSTEM) and OTHER_GROUPS.

Example: Using the CREATE_SIMPLE_PLAN Procedure

BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN(SIMPLE_PLAN => 'simple_plan1',
CONSUMER_GROUP1 => 'mygroup1', GROUP1_CPU => 80,
CONSUMER_GROUP2 => 'mygroup2', GROUP2_CPU => 20);
END;

Executing the preceding statements creates the following plan:

Consumer Group Level 1 Level 2 Level 3
SYS_GROUP 100% - -
mygroup1 - 80% -
mygroup2 - 20% -
OTHER_GROUPS - - 100%

Quoted from "http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/dbrm.htm#sthref3300"

标签

#Oracle #UP