Optimize Distributed Workload - Expert Oracle RAC Performance Diagnostics and Tuning - page 513

BEGIN
DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP
(CONSUMER_GROUP=>'LOW_PRIORITY',
COMMENT=>'Low Priority group');
END;
/
Step 7.3 Map Consumer Groups to Services
Once the consumer groups are defined, the next step is to map the consumer group to its respective services; for
example, consumer group HIGH_PRIORTY will be used by both TAPS and TICKS:
BEGIN
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING
(ATTRIBUTE=>DBMS_RESOURCE_MANAGER.SERVICE_NAME,
VALUE=> 'TAPS',
CONSUMER_GROUP=>'HIGH_PRIORITY');
END;
/
In the preceding output, service TAPS is mapped to HIGH_PRIORITY , indicating that it's governed by the resource
criteria defined for consumer group HIGH_PRIORITY .
BEGIN
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING
(ATTRIBUTE=>DBMS_RESOURCE_MANAGER.SERVICE_NAME,
VALUE=> 'SSKY',
CONSUMER_GROUP=>'STD_PRIORITY');
END;
/
In the preceding output, service SSKY is mapped to STD_PRIORITY , indicating that it's governed by the resource
criteria defined for consumer group STD_PRIORITY .
BEGIN
DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING
(ATTRIBUTE=>DBMS_RESOURCE_MANAGER.SERVICE_NAME,
VALUE=> 'GRUD',
CONSUMER_GROUP=>'LOW_PRIORITY');
END;
/
In the preceding output, service GRUD is mapped to LOW_PRIORITY , indicating that it's governed by the resource
criteria defined for consumer group LOW_PRIORITY .