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

historical IORM metrics using the list metrichistory CellCLI command and summarize the data using techniques
presented in Chapter 13.
In this section of the recipe, we have only displayed a subset of the available IORM metrics. Please refer to the
list metricdefinition output to obtain a complete list of available metrics and the How It Works section of this
recipe to learn what we consider to be the most commonly monitored IORM-related storage cell metrics.
Using metric_iorm.pl to Measure IORM Performance Impact
Another way to measure IORM performance statistics is via the metric_iorm.pl Perl script, which you can download
from My Oracle Support note 1337265.1. This script collects performance statistics from multiple IORM metrics and
summarizes into an easy-to-read report, as displayed:
[root@cm01cel01 ~]# ./metric_iorm.pl
... Additional database detail omitted for brevity
Database: VISY
Utilization: Small=0% Large=4%
Flash Cache: IOPS=6.1
Throughput: MBPS=110
Small I/O's: IOPS=4.7 Avg qtime=5.1ms
Large I/O's: IOPS=108 Avg qtime=347ms
Consumer Group: CG_ADHOC
Utilization: Small=0% Large=1%
Flash Cache: IOPS=0.0
Throughput: MBPS=33
Small I/O's: IOPS=0.2 Avg qtime=22.9ms
Large I/O's: IOPS=33.1 Avg qtime=1111ms
... Other consumer groups omitted for brevity
Consumer Group: CG_FINANCE
Utilization: Small=0% Large=1%
Flash Cache: IOPS=0.0
Throughput: MBPS=44
Small I/O's: IOPS=2.1 Avg qtime=8.1ms
Large I/O's: IOPS=43.0 Avg qtime=5.2ms
Consumer Group: CG_PROJECTS
Utilization: Small=0% Large=1%
Flash Cache: IOPS=0.0
Throughput: MBPS=32
Small I/O's: IOPS=0.4 Avg qtime=3.6ms
Large I/O's: IOPS=31.7 Avg qtime=12.7ms
... Other consumer groups omitted for brevity
DISK LATENCY METRICS
Avg small read latency: 37.70 ms
Avg small write latency: 0.86 ms
Avg large read latency: 79.87 ms
Avg large write latency: 0.00 ms
[root@cm01cel01 ~]#
The output in the metric_iorm.pl script is separated by database, with database-wide performance statistics
provided including the I/O utilization broken down by small I/O and large I/O, Flash Cache I/Os per second, I/O
bandwidth measured in megabytes per second, as well as small I/O and large I/O per second and average queue