General: Resource manager simple plan

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

exec dbms_resource_manager.create_pending_area;

BEGIN
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING
(DBMS_RESOURCE_MANAGER.ORACLE_USER, 'test', 'mygroup2');
END;
/

exec dbms_resource_manager.submit_pending_area;

18:27:16 38 447 TEST@orcl> select initial_rsrc_consumer_group from dba_users where username = 'TEST';

INITIAL_RSRC_CONSUMER_GROUP
------------------------------
MYGROUP2

alter system set resouce_manager_plan=simple_plan1;