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
Using vxstorage_stats
Chapter 6
121
Using vxstorage_stats
The vxstorage_stats command displays detailed storage mapping information and I/O
statistics about one or more VxFS files. The mapping information and
I/O statistics are recorded only for VxFS files and VxVM volumes.
In vxstorage_stats command output, I/O topology information appears first followed by
summary statistics for each object.
The command syntax is as follows:
/opt/VRTSdbed/bin/vxstorage_stats [-m] [-s] [-i interval -c count] -f
filename
Displaying Storage Mapping Information
To display storage mapping information
• Use the vxstorage_stats command with the -m option to display storage mapping
information:
$ /opt/VRTSdbed/bin/vxstorage_stats -m -f file_name
For example:
$ /opt/VRTSdbed/bin/vxstorage_stats -m -f /oradata/system01.dbf
Output similar to the following is displayed:
TYNAMENSUBDESCRIPTIONSIZE(sectors)OFFSET(sectors) PROPERTIES
fi/oradata/system01.dbf1FILE2621442048(B)4718592(B)
Extents:3 Sparse Extents:0
vmyindex1MIRROR167772160
plvxvm:mydb/myindex-01 3STRIPE167792640Stripe_size:2048
rd/dev/vx/rdmp/c3t1d3s31PARTITION55930880
sd/dev/rdsk/c3t1d3s31PARTITION17674560960
Table 6-2 vxstorage_stats Syntax
Prerequisites You must log in as the database administrator (typically, the user ID
oracle) or superuser.
Usage Notes • The -s specified option displays the file statistics for the
specified file.
•The -c count option specifies the number of times to display
statistics within the interval specified by -i interval.
•The -i interval option specifies the interval frequency for
displaying updated I/O statistics.
•The -f filename option specifies the file to display I/O mapping
and statistics for.
•The -m option displays the I/O topology for the specified file.
• For more information, see the vxstorage_stats(1m) online
manual page.