Previous  |  Next  >  
Product: Storage Foundation for Oracle RAC Guides   
Manual: Storage Foundation 4.1 for Oracle RAC Installation and Configuration   

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   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
 ^ Return to Top Previous  |  Next  >  
Product: Storage Foundation for Oracle RAC Guides  
Manual: Storage Foundation 4.1 for Oracle RAC Installation and Configuration  
VERITAS Software Corporation
www.veritas.com