The syntax for the SET_INITIAL_
CONSUMER_GROUP procedure is shown in the following listing:
Chapter 5: Developing and Implementing Applications 139
SET_INITIAL_CONSUMER_GROUP
(user IN VARCHAR2,
consumer_group IN VARCHAR2)
If a user has never had an initial consumer group set via the SET_INITIAL_CONSUMER_GROUP
procedure, the user is automatically enrolled in the resource consumer group named DEFAULT_
CONSUMER_GROUP.
To enable the Resource Manager within your database, set the RESOURCE_MANAGER_PLAN
database initialization parameter to the name of the resource plan for the instance. Resource plans
can have subplans, so you can create tiers of resource allocations within the instance. If you do
not set a value for the RESOURCE_MANAGER_PLAN parameter, resource management is not
performed in the instance.
You can dynamically alter the instance to use a different resource allocation plan using the
RESOURCE_MANAGER_PLAN initialization parameter: for example, you could create a resource
plan for your daytime users (DAYTIME_USERS) and a second for your batch users (BATCH_
USERS). You could create a job that each day executes this command at 6:00 A.M.:
alter system set resource_manager_plan = 'DAYTIME_USERS';
Then at a set time in the evening, you could change consumer groups to benefit the batch users:
alter system set resource_manager_plan = 'BATCH_USERS';
The resource allocation plan for the instance will thus be altered without needing to shut down
and restart the instance.
Pages:
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257