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

17-7. Obtaining IORM Plan Information
Problem
You wish to list the details of your currently enabled IORM plan in order to understand how your plan is configured.

Solution
In this recipe, you will learn how to display your currently enabled IORM plan details using two methods, with
CellCLI's list iormplan command and by generating a Cell Services statedump .
Begin by running the following CellCLI command from one of your storage cells:

CellCLI> list iormplan detail
name: cm01cel01_IORMPLAN
catPlan: name=CAT_HIGH,level=1,allocation=100
name=CAT_MEDIUM,level=2,allocation=80
name=CAT_LOW,level=2,allocation=20
name=other,level=3,allocation=100
dbPlan: name=edw,level=1,allocation=55
name=visx,level=1,allocation=25
name=dwprd,level=1,allocation=15
name=visy,level=1,allocation=5
name=other,level=2,allocation=100
objective: auto
status: active
CellCLI>

We see an active IORM plan with a combination of Category IORM and Interdatabase IORM configured using the
auto IORM plan objective. Recipes 17-1 through 17-5 walk you through examples of how to create these types of IORM
plans and, in the How It Works section of Recipe 17-5, we elaborate on the details of how Exadata implements I/O
resource management functionality with IORM.
To provide a more comprehensive picture of your IORM plans, execute the following command from CellCLI to
generate a cell services ( cellsrv ) statedump :

CellCLI> alter cell events = "immediate cellsrv.cellsrv_statedump(0,0)"
Dump sequence #1 has been written to /opt/oracle/cell11.2.3.1.1_LINUX.X64_120607/log/diag/asm/cell/
cm01cel01/trace/svtrc_12910_71.trc
Cell cm01cel01 successfully altered
CellCLI>

The cellsrv statedump is written to a text file reported in the output of your alter cell events command.
Open this file with a text editor and look for the following:

1. Search for the text “IORM state dump” to find the beginning of your IORM configuration.

In the following, we see that an IORM plan is currently enabled and I/O is being
“throttled” based on the plan's rules:

-------------------------------------------------------------------------
IORM state dump
-------------------------------------------------------------------------
Time: 11-25-2012 23:49:52.084883000
IORM Enabled: Active Plan, Throttling
Current IORM Plans