ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle simple resource plan

Oracle simple resource plan

原创 Linux操作系统 作者:keeptrying 时间:2012-06-05 13:12:05 0 删除 编辑

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 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. Each consumer group specified in the plan is allocated its CPU percentage at level 2. 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.

 

For example

BEGIN

DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN(SIMPLE_PLAN => 'simple_plan1',

   CONSUMER_GROUP1 => 'mygroup1', GROUP1_CPU => 80,

   CONSUMER_GROUP2 => 'mygroup2', GROUP2_CPU => 20);

END;

 

Consumer Group

Level 1

Level 2

Level 3

SYS_GROUP

100%

-

-

mygroup1

-

80%

-

mygroup2

-

20%

-

OTHER_GROUPS

-

-

100%

 

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25744374/viewspace-731952/,如需转载,请注明出处,否则将追究法律责任。

上一篇: Oracle SYSTEM_PLAN
下一篇: Oracle pending area
请登录后发表评论 登录
全部评论

注册时间:2011-04-25

  • 博文量
    130
  • 访问量
    912395