CREATE_CONSUMER_GROUP -
(Consumer_Group => 'Batch_developers', -
Comment => 'Batch developers');
Once the plan and resource consumer groups are established, you need to create resource
plan directives and assign users to the resource consumer groups. To assign directives to a plan,
use the CREATE_PLAN_DIRECTIVE procedure of the DBMS_RESOURCE_MANAGER package.
The syntax for the CREATE_PLAN_DIRECTIVE procedure is shown in the following listing:
CREATE_PLAN_DIRECTIVE
(plan IN VARCHAR2,
group_or_subplan IN VARCHAR2,
comment IN VARCHAR2,
cpu_p1 IN NUMBER DEFAULT NULL,
cpu_p2 IN NUMBER DEFAULT NULL,
138 Oracle Database 11g DBA Handbook
cpu_p3 IN NUMBER DEFAULT NULL,
cpu_p4 IN NUMBER DEFAULT NULL,
cpu_p5 IN NUMBER DEFAULT NULL,
cpu_p6 IN NUMBER DEFAULT NULL,
cpu_p7 IN NUMBER DEFAULT NULL,
cpu_p8 IN NUMBER DEFAULT NULL,
active_sess_pool_p1 IN NUMBER DEFAULT UNLIMITED,
queueing_p1 IN NUMBER DEFAULT UNLIMITED,
parallel_degree_limit_p1 IN NUMBER DEFAULT NULL,
switch_group IN VARCHAR2 DEFAULT NULL,
switch_time IN NUMBER DEFAULT UNLIMITED,
switch_estimate IN BOOLEAN DEFAULT FALSE,
max_est_exec_time IN NUMBER DEFAULT UNLIMITED,
undo_pool IN NUMBER DEFAULT UNLIMITED,
max_idle_time IN NUMBER DEFAULT NULL,
max_idle_time_blocker IN NUMBER DEFAULT NULL,
switch_time_in_call IN NUMBER DEFAULT NULL);
The multiple CPU variables in the CREATE_PLAN_DIRECTIVE procedure support the creation
of multiple levels of CPU allocation.
Pages:
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255