For example, you could allocate 75 percent of all your CPU
resources (level 1) to your online users. Of the remaining CPU resources (level 2), you could
allocate 50 percent to a second set of users. You could split the remaining 50 percent of resources
available at level 2 to multiple groups at a third level. The CREATE_PLAN_DIRECTIVE procedure
supports up to eight levels of CPU allocations.
The following example shows the creation of the plan directives for the ONLINE_DEVELOPERS
and BATCH_DEVELOPERS resource consumer groups within the DEVELOPERS resource plan:
execute DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE -
(Plan => 'DEVELOPERS', -
Group_or_subplan => 'ONLINE_DEVELOPERS', -
Comment => 'online developers', -
Cpu_p1 => 75, -
Cpu_p2=> 0, -
Parallel_degree_limit_p1 => 12);
execute DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE -
(Plan => 'DEVELOPERS', -
Group_or_subplan => 'BATCH_DEVELOPERS', -
Comment => 'Batch developers', -
Cpu_p1 => 25, -
Cpu_p2 => 0, -
Parallel_degree_limit_p1 => 6);
In addition to allocating CPU resources, the plan directives restrict the parallelism of
operations performed by members of the resource consumer group. In the preceding example,
batch developers are limited to a degree of parallelism of 6, reducing their ability to consume
system resources. Online developers are limited to a degree of parallelism of 12.
To assign a user to a resource consumer group, use the SET_INITIAL_CONSUMER_GROUP
procedure of the DBMS_RESOURCE_MANAGER package.
Pages:
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256