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 exist 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.
Some highlights on this command:
- You must log in as the database administrator (typically, the user ID oracle).
- The -m option displays the I/O topology for the specified file.
- The -s option displays the file statistics for the specified file.
- The -c count option specifies the number of times to display statistics.
- 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.
- Refer the vxstorage_stats(1m) online manual page for more information.
Displaying Storage Mapping Information
Use the vxstorage_stats command with the -m option to display storage mapping information:
$ /opt/VRTSormap/bin/vxstorage_stats -m -f file_name
For example:
$ /opt/VRTSormap/bin/vxstorage_stats -m -f /oradata/system01.dbf
Note
For file type (fi), the SIZE column is number of bytes; 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.
Displaying I/O Statistics Information
To display I/O statistics information, use the vxstorage_stats command with the -s option:
$ /opt/VRTSormap/bin/vxstorage_stats -s -f file_name
For example:
$ /opt/VRTSormap/bin/vxstorage_stats -s -f \ /data/system01.dbf/PRODqio/PRODqiotbs
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/VRTSormap/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/VRTSormap/bin/vxstorage_stats -s -i2 -c2 \ -f /data/system01.dbf
|