Update Resource Plan Directive

BEGIN
    -- Prepare the pending area
    DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA;
    DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;

    DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
        plan => 'OLTP_PLAN'
       ,group_or_subplan => 'SYS_GROUP'
       ,new_cpu_p1 => 30
    );
    DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE(
        plan => 'OLTP_PLAN'
       ,group_or_subplan => 'OTHER_GROUPS'
       ,new_cpu_p1 => 4
    );

    -- Submit the changes
    DBMS_RESOURCE_MANAGER.VALIDATE_PENDING_AREA;
    DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;

END;
/