Veritas Storage Foundation for Oracle 5.0 Administrator's Guide, HP-UX 11i v3, Second Edition, December 2008
Displaying I/O mapping and statistics using vxstorage_stats
You can use the vxstorage_stats command to display I/O mapping and statistics
about Veritas File System files one file at a time. The statistics are recorded only
for VxFS files and VxVM volumes. These statistics show I/O activity.
Before displaying I/O mapping and statistics, the following conditions must be
met:
■ You may be logged in as either the database administrator or root.Prerequisites
Command usage for vxstorage_stats is as follows:
$ /opt/VRTS/bin/vxstorage_stats [-m] [-s] [-i interval -c count ] \
-f file_name
Table A-9 lists options for the vxstorage_stats command.
Table A-9
vxstorage_stats command options
DescriptionOption
Displays the I/O topology for the specified file.-m
Displays the file statistics for the specified file.-s
Specifies the number of times to display statistics.-c count
Specifies the interval frequency for displaying updated I/O statistics.-i interval
Specifies the file to display I/O mapping and statistics for.-f filename
To display I/O mapping information
◆
Use the vxstorage_stats command with the -m option as follows:
$ /opt/VRTS/bin/vxstorage_stats -m -f \
/oradata/system01.dbf
For file type (fi), the SIZE column is number of bytes, and for volume (v),
plex (pl), sub-disk (sd), and physical disk (da), the SIZE column is in 512-byte
blocks. Stripe sizes are given in sectors.
To display the entire I/O mapping and statistics for each I/O stack
◆
Use the vxstorage_stats command with the -m and -s options as follows:
$ /opt/VRTS/bin/vxstorage_stats -m -s -f /data/system01.dbf
Veritas Storage Foundation for Oracle Command Line Interface
About the command line interface
362