Resource Manager

Privileges
System privilege ADMINISTER_RESOURCE_MANAGER required to administer the Database Resource Manager.
EXEC DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SYSTEM_PRIVILEGE(
  GRANTEE_NAME => 'scott', PRIVILEGE_NAME =>'ADMINISTER_RESOURCE_MANAGER', ADMIN_OPTION => FALSE);

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

Add a database service to a Resource Consumer group
EXEC DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;
    
EXECUTE DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP(consumer_group => 'HIGH', 
  commnent => 'High priority consumer group'); 
  
EXECUTE DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING(attribute => DBMS_RESOURCE_MANAGER.SERVICENAME, 
  value => 'SERVICEl'); 
  
EXEC DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA;

EXEC DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;

EXECUTE DBMS_RESOURCE_MANAGER_PRIVS.GRANT_SWITCH_CONSUMER_GROUP(grantee_name=> 'PUBLIC, 
  consumer_group => 'HIGH', grant_option=> FALSE); 

EXEC DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA;