I/O Resource Management and Instance Caging - Oracle Exadata Recipes: A Problem-Solution Approach - page 502

17-5. Prioritizing I/O Utilization by Categories of Resource
Consumers and Databases
Problem
You wish to implement I/O resource utilization control on your Exadata storage cells across categories of resource
consumers and Exadata databases.

Solution
In this recipe, you will learn how to implement an IORM plan, which is defined as a Category IORM plan plus an
Interdatabase IORM plan.
Creating an IORM plan is achieved by using the alter iormplan CellCLI command with both the dbplan and
catplan directives. Before creating your IORM plan, you must do the following:

1. Gather business requirements for your databases, resource consumers within each

database, and classifications of resources (in other words, categories) across each database.

2. Build your Intradatabase plans on each of the databases that you wish to control resources

on DBRM. Recipe 17-3 provides instructions on how to accomplish these steps using the
DBMS_RESOURCE_MANAGER PL/SQL package procedures.

3. Create resource categories in each of your databases using the

DBMS_RESOURCE_MANAGER.CREATE_CATEGORY and assign your categories to the proper
resource consumer groups.

4. Review the expected I/O utilization capacity numbers using tips provided in the How It

Works section of this recipe or by consulting Oracle's IORM documentation.

5. Implement your IORM plan across your storage cells.
Following is an example that uses dcli with the alter iormplan CellCLI command to enable an IORM
plan across all of your storage cells. We will number each of the lines and provide a description of what each line
accomplishes after the listing output:

1. [oracle@cm01dbm01 iorm]$ dcli -g ./cell_group "cellcli -e alter iormplan inactive"
2. cm01cel01: IORMPLAN successfully altered
3. cm01cel02: IORMPLAN successfully altered
4. cm01cel03: IORMPLAN successfully altered
5. [oracle@cm01dbm01 iorm]$ dcli -g ./cell_group "cellcli -e \
6. > alter iormplan objective=\'auto\', \
7. > dbplan=\(\(name=edw,level=1,allocation=55\), \
8. > \(name=visx,level=1,allocation=25\), \
9. > \(name=dwprd,level=1,allocation=15\), \
10. > \(name=visy,level=1,allocation=5\), \
11. > \(name=other,level=2,allocation=100\)\), \
12. > catplan=\(\(name=CAT_HIGH,level=1,allocation=100\), \
13. > \(name=CAT_MEDIUM,level=2,allocation=80\), \
14. > \(name=CAT_LOW,level=2,allocation=20\), \