Veritas Storage Foundation 5.0 for Oracle RAC Configuration Guide Extracts for HP Serviceguard Storage Management Suite, Second Edition, May 2008

Investigating I/O Performance for SG Oracle RAC: Storage Mapping
Displaying I/O Statistics Information
Chapter 6
123
Displaying I/O Statistics Information
To display I/O statistics information
•Use the vxstorage_stats command with the -s option to display I/O statistics
information:
$ /opt/VRTSdbed/bin/vxstorage_stats -s -f file_name
For example:
$ /opt/VRTSdbed/bin/vxstorage_stats -s -f \
/data/system01.dbf
Output similar to the following is displayed:
I/O OPERATIONSI/O BLOCKS(512 byte)AVG TIME(ms)
OBJECTREADWRITEB_READB_WRITEAVG_RDAVG_WR
/data/system01.dbf22479850688100.0053.28
/dev/vx/rdsk/mydb/myindex10124971592506905612.1852.78
vxvm:mydb/myindex-0110124971592506905612.1852.76
/dev/rdsk/c3t1d3s313116562096168969614.4339.09
c3t1d313116562096168969614.4339.09
EMC000184502242:02:0c:02848023101927595223296162--
EMC000184502242:31:0c:0232442321315480823451325--
/dev/rdsk/c3t1d15s401652016896060.0046.47
c3t1d1501652016896060.0046.47
EMC000184502242:01:0c:02238241188997103833632407727--
EMC000184502242:32:0c:02508585238413567229956179--
/dev/rdsk/c3t1d2s4141668200168983418.5734.19
c3t1d2141668200168983418.5734.19
EMC000184502242:16:0c:02440627115512136823463948--
EMC000184502242:17:0c:0232902692815543223304619--
To display storage mapping and I/O statistics information at repeated intervals
•Use the vxstorage_stats command with the -i interval and -c count options.
The -i interval option specifies the interval frequency for displaying updated I/O
statistics and the -c count option specifies the number of times to display statistics:
$ /opt/VRTSdbed/bin/vxstorage_stats [-m] [-s] \[-i interval -c count ]
-f file_name
For example, type the following command to display statistics two times with a time
interval of two seconds:
$ /opt/VRTSdbed/bin/vxstorage_stats -s -i2 -c2 \-f /data/system01.dbf
Output similar to the following is displayed:
I/O OPERATIONSI/O BLOCKS(512 byte)AVG TIME(ms)
OBJECTREADWRITEB_READB_WRITEAVG_RDAVG_WR
/oradata/system01.dbf1191713102953365944022.84278.81
/dev/vx/rdsk/ramdg/oradata11959147291058397048113.11295.20
vxvm:ramdg/oradata-0111947147291077837047993.14295.23
/dev/rhdisk1359748366536633522072.95246.65
EMC000184502242:02:0c:01573332049897--