You can also modify the Directive using the procedure UPDATE_PLAN_DIRECTIVE found in the DBMS_RESOURCE_MANAGER package.

DECLARE

PLAN VARCHAR2(200);

GROUP_OR_SUBPLAN VARCHAR2(200);

NEW_ACTIVE_SESS_POOL_P١ NUMBER;

NEW_MAX_IDLE_TIME NUMBER;

BEGIN

PLAN := 'NEW_PLAN';

GROUP_OR_SUBPLAN :='NEW_GROUP';

NEW_ACTIVE_SESS_POOL_P1 := 7;

NEW_MAX_IDLE_TIME := 7;

SYS.DBMS_RESOURCE_MANAGER.CLEAR_PENDING_AREA;

SYS.DBMS_RESOURCE_MANAGER.CREATE_PENDING_AREA;

SYS.DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE (PLAN, GROUP_OR_SUBPLAN, NEW_ACTIVE_SESS_POOL_P١,NEW_MAX_IDLE_TIME );

SYS.DBMS_RESOURCE_MANAGER.SUBMIT_PENDING_AREA;

COMMIT;

END;