资源管理----CREATE_SIMPLE_PLAN Procedure

文档地址：http://docs.oracle.com/cd/B19306_01/appdev.102/b14258/d_resmgr.htm#i996990

CREATE_SIMPLE_PLANProcedure

This procedure creates a single-level resource plancontaining up to eight consumer groups in one step.（这个简单计划创建是针对单一级别的，为level2。它共包含8个用户组，也可以在8个以下，默认用户组SYS_GROUP在level1级别上拥有100%的CPU资源，然后再到本计划创建的指令，然后再到用户组other_group拥有100%的CPU资源。见下例子） Youdo not need to create a pending area manually before creating aresource plan, or use the CREATE_CONSUMER_GROUP andCREATE_RESOURCE_PLAN_DIRECTIVES proceduresseparately.

Syntax

DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (SIMPLE_PLAN      IN  VARCHAR2  DEFAULT,CONSUMER_GROUP1  IN  VARCHAR2  DEFAULT,GROUP1_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP2  IN  VARCHAR2  DEFAULT,GROUP2_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP3  IN  VARCHAR2  DEFAULT,GROUP3_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP4  IN  VARCHAR2  DEFAULT,GROUP4_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP5  IN  VARCHAR2  DEFAULT,GROUP5_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP6  IN  VARCHAR2  DEFAULT,GROUP6_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP7  IN  VARCHAR2  DEFAULT,GROUP7_CPU       IN  NUMBER    DEFAULT,CONSUMER_GROUP8  IN  VARCHAR2  DEFAULT,GROUP8_CPU       IN  NUMBER    DEFAULT);

例子：

You execute the following command to create two consumer groups,FIN_GROUP1 and
PAY_GROUP1, for a plan, PROD_PLAN:

BEGIN
DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (SIMPLE_PLAN=> 'prod_plan',
CONSUMER_GROUP1 => 'fin_group1',
GROUP1_CPU => 80,
CONSUMER_GROUP2 => 'pay_group1',
GROUP2_CPU => 20);
END;

这个简单计划创建结果是：

一、SYS_GROUP gets 100% CPU resources at level 1。

二、FIN_GROUP1 gets 80% CPU resources at level 2；PAY_GROUP1 gets20% CPU resources at level 2。 三、OTHER_GROUP gets 100% CPU resourcesat level 3---other_group组在每个资源管理计划都必须拥有一条针对这个用户组的指令。