Oracle in a Nutshell

Calls

PROCEDURE DBMS_RESOURCE_MANAGER.CREATE_PLAN (plan IN VARCHAR2, comment IN VARCHAR2, cpu_mth IN VARCHAR DEFAULT 'EMPHASIS', active_sess_pool_mth | max_active_sess_target IN VARCHAR2 DEFAULT 'ACTIVE_SESSION_POOL_ABSOLUTE', parallel_degree_limit_mth IN VARCHAR2 DEFAULT 'PARALLEL_DEGREE_LIMIT_ABSOLUTE', queueing_mth IN VARCHAR2 DEFAULT 'FIFO_TIMEOUT');

Creates a resource plan plan with methods indicated in the parameters. In Oracle 8.2, max_active_sess_target was renamed to active_sess_pool_mth and queueing_mth was added.

PROCEDURE DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN (simple_plan IN VARCHAR2, consumer_group1 in VARCHAR2, group1_cpu IN VARCHAR2, consumer_group2 in VARCHAR2, group2_cpu IN VARCHAR2, consumer_group3 in VARCHAR2, group3_cpu IN VARCHAR2, consumer_group4 in VARCHAR2, group4_cpu IN VARCHAR2, consumer_group5 in VARCHAR2, group5_cpu IN VARCHAR2, consumer_group6 in VARCHAR2, group6_cpu IN VARCHAR2, consumer_group7 in VARCHAR2, group7_cpu IN VARCHAR2, consumer_group8 in VARCHAR2, group8_cpu IN VARCHAR2);

Creates simple_plan resource plan with up to eight consumer groups in one call. New with Oracle9i.

PROCEDURE DBMS_RESOURCE_MANAGER.UPDATE_PLAN (plan IN VARCHAR2, new_comment IN VARCHAR2, new_cpu_mth IN VARCHAR DEFAULT NULL, new_active_sess_pool_mth | new_max_active_sess_target IN VARCHAR2 DEFAULT NULL, new_parallel_degree_limit_mth IN VARCHAR2 DEFAULT NULL, new_queueing_mth IN VARCHAR2 DEFAULT NULL [,new_group_switch_mth IN VARCHAR2 DEFAULT NULL)]#;

Updates ...