Menu Close

Month: November 2019

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 =>…