Using vxstorage_stats
The vxstorage_stats command displays detailed storage mapping information and I/O statistics about an individual VxFS file. 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
Prerequisites
- You must log in as the database administrator (typically, the user ID oracle) or root.
Usage Notes
- 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 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.
- For more information, see the vxstorage_stats(1m) online manual page.
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
Example
$ /opt/VRTSdbed/bin/vxstorage_stats -m -f /oradata/system01.dbf
Output similar to the following is displayed:
Note
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.
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
Example
$ /opt/VRTSdbed/bin/vxstorage_stats -s -f \ /data/system01.dbf
Output similar to the following is displayed:
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 to display storage mapping and I/O statistics information at repeated intervals. 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
Example
To display statistics twice 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:
|