The Resource Manager is one of the strongest features of the database; however, it is not necessarily the case that strong features are easy to use, as you can see that the matter is not simple.

Therefore, Oracle provided the Simple Plan, which helps you with the creation of Resource Plan, Resource Consumer Group, and Plan Directive in a straightforward and easy manner.

This procedure always provides a 100% allocation at the first level of CPU resources for the SYS_GROUP, and an allocation of 100% at the third level of CPU resources for the OTHER_GROUPS. The second level is divided among the groups according to the requirements specified in the CREATE_SIMPLE_PLAN procedure.

This procedure does not require the preparation and creation of the Pending Area, as is the case in previous procedures.

DECLARE

SIMPLE_PLAN VARCHAR2(200);

CONSUMER_GROUP١ VARCHAR2(200);

GROUP1_CPU NUMBER;

BEGIN

SIMPLE_PLAN := 'TEST_PLAN';

CONSUMER_GROUP1 := 'NEW_GROUP';

GROUP1_CPU := 100;

SYS.DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (SIMPLE_PLAN, CONSUMER_GROUP١, GROUP١_CPU );

COMMIT;

END;

Thus, we created a Plan named TEST_PLAN. This Plan grants the Consumer Group named NEW_GROUP 100% CPU resources at the second level.

As for the first level, it is as we mentioned for the SYS_GROUP at 100%, while the third level is for the OTHER_GROUPS at 100%.