Monitoring Exadata Storage Cells - Oracle Exadata Recipes: A Problem-Solution Approach - page 400

cm01cel01: DB_IO_WT_LG_RQ DWPRD 0.0 ms/request
cm01cel01: DB_IO_WT_LG_RQ EDW 0.0 ms/request
... Output omitted
cm01cel01: DB_IO_WT_SM_RQ DWPRD 0.0 ms/request
cm01cel01: DB_IO_WT_SM_RQ EDW 0.0 ms/request
... Output omitted
Measuring I/O Load and I/O Waits per Resource Consumer Group
To determine which consumer groups are contributing the most to your Exadata I/O load to your hard disks, run the
following cellcli command using the CG_IO_LOAD metric:
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group "cellcli -e list metriccurrent \
where objectType=\'IORM_CONSUMER_GROUP\' \
and name=\'CG_IO_LOAD\'"
... Output omitted
To measure the small and large I/O waits per resource consumer group, use the CG_IO_WT_.*_RQ metrics with the
following dcli command:
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group "cellcli -e list metriccurrent \
> where objectType=\'IORM_CONSUMER_GROUP\' \
> and name like \'CG_IO_WT_.*_RQ\'"
cm01cel01: CG_IO_WT_LG_RQ DWPRD.OTHER_GROUPS 0.0 ms/request
cm01cel01: CG_IO_WT_LG_RQ DWPRD.SYS_GROUP 0.0 ms/request
cm01cel01: CG_IO_WT_LG_RQ DWPRD._ORACLE_LOWPRIBG_GROUP_ 0.0 ms/request
cm01cel01: CG_IO_WT_LG_RQ DWPRD._ORACLE_LOWPRIFG_GROUP_ 0.0 ms/request
... Output omitted
Measuring I/O Load and I/O Waits per Resource Category
To determine which resource categories are contributing the most to your Exadata I/O load to your hard disks, run the
following cellcli command using the CT_IO_LOAD metric:
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group "cellcli -e list metriccurrent \
> where objectType=\'IORM_CATEGORY\' \
> and name=\'CT_IO_LOAD\'"
cm01cel01: CT_IO_LOAD CAT_HIGH 0
cm01cel01: CT_IO_LOAD CAT_LOW 0
cm01cel01: CT_IO_LOAD CAT_MEDIUM 0
cm01cel01: CT_IO_LOAD OTHER 0
cm01cel01: CT_IO_LOAD _ASM_ 0
[oracle@cm01dbm01 ~]$
To measure the small and large I/O waits per resource consumer group, use the CT_IO_WT_.*_RQ metrics with the
following dcli command:
[oracle@cm01dbm01 ~]$ dcli -g ./cell_group "cellcli -e list metriccurrent \
> where objectType=\'IORM_CATEGORY\' \
> and name like \'CT_IO_WT_.*_RQ\'"