Databases Reference
In-Depth Information
17-4. Prioritizing I/O Utilization by Category of
Resource Consumers
Problem
You wish to govern I/O resource utilization on your Exadata storage cells based on database resource categories, or
classifications of consumer workload across multiple databases.
Solution
In this recipe, you will learn how to assign DBRM consumer groups to resource categories and use these categories
to create a Category IORM plan. We will demonstrate Category IORM implementation by using DBRM consumer
groups created in Recipe 17-3. To learn more about resource consumer group creation and the steps to create an
Intradatabase IORM plan, please refer to Recipe 17-3.
First, create DBRM categories in each of your databases using the
DBMS_RESOURCE_MANAGER
PL/SQL API. In the following, we will create three resource categories,
CAT_HIGH
,
CAT_LOW
,
and
CAT_MEDIUM
.
1.
SYS @ visx1> begin
dbms_resource_manager.create_pending_area();
dbms_resource_manager.create_category(category=>'CAT_HIGH', comment=>'CAT_HIGH');
dbms_resource_manager.create_category(category=>'CAT_MEDIUM',comment=>'CAT_MEDIUM');
dbms_resource_manager.create_category(category=>'CAT_LOW',comment=>'CAT_LOW');
dbms_resource_manager.validate_pending_area();
dbms_resource_manager.submit_pending_area();
end;
/
PL/SQL procedure successfully completed.
SYS @ visx1>
2.
After the DBRM categories are created, assign your DBRM resource consumer groups to
the desired categories created in the previous step:
SYS @ visx1> begin
dbms_resource_manager.create_pending_area();
dbms_resource_manager.update_consumer_group(consumer_group=>'CG_SHIPPING',
new_category=>'CAT_HIGH');
dbms_resource_manager.update_consumer_group(consumer_group=>'CG_FINANCE',
new_category=>'CAT_MEDIUM');
dbms_resource_manager.update_consumer_group(consumer_group=>'CG_REPORTING',
new_category=>'CAT_LOW');
dbms_resource_manager.validate_pending_area();
dbms_resource_manager.submit_pending_area();
end;
/
SYS @ visx1>
Search WWH ::
Custom Search