December 2002
Intermediate to advanced
928 pages
85h 29m
English
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 ...