Home > Veritas Storage Foundation™ for Oracle Manual Pages
VXSTORAGE_STATS (1) |
User Commands |
[-i interval -c count ] -f filenameFor DB2: /opt/VRTSdb2ed/bin/vxstorage_stats [-m] [-s]
[-i interval -c count ] -f filename
AVAILABILITY
This command is part of Veritas Storage Foundation for Databases.
To determine whether Veritas Storage Foundation for Oracle is installed on an \1 system, enter:
lslpp -L VRTSdbed
To determine whether Veritas Storage Foundation for DB2 is installed on an \1 system, enter:
lslpp -L VRTSdb2ed
DESCRIPTION
The vxstorage_stats command prints I/O mapping and statistics about one or more Veritas File System files. The statistics are recorded only for VxFS files and VxVM volumes. These statistics show I/O activity.
OPTIONS
The following options are supported:
- -m
- Displays the I/O stack mapping topology for the specified file.
- -s
- Displays the file statistics for the specified file.
- -c count
- Specifies the number of times to print statistics. -i interval is required to use -c count.
- -i interval
- Specifies the interval frequency for printing updated I/O statistics. If the -i interval option is supplied, statistics are prefaced with a time stamp showing the current local time on the system. If -i interval and -c count are not specified, the default is one count (that is, statistics will be printed a single time). Note: I/O topology information is printed first; subsequent refreshes display statistics only.
- -f filename
- Specifies the file to print I/O mapping and statistics for.
NOTES
In vxstorage_stats command output, I/O topology information appears first followed by summary statistics for each object. Summary statistics are printed in single line output records, preceded by two header lines. The output line consists of the following space-separated fields:
- file name
- number of read operations
- number of write operations
- number of blocks read
- number of blocks written
- average time spent on read operations in the interval
- average time spent on write operations in the interval
The vxstorage_stats command exits with a non-zero status if the attempted operation fails. A non-zero exit code is returned for the first condition that prevented execution of the utility.
EXAMPLES
Note that for Oracle, the command is located under /opt/VRTSdbed/bin. For DB2, it is located under /opt/VRTSdb2ed/bin.To print the entire I/O mapping:
# /opt/VRTSdbed/bin/vxstorage_stats -m -f /data/system01.dbf TY NAME NSUB DESCRIPTION SIZE(sectors) OFFSET(sectors) PROPERTIES fi /oradata/system01.dbf 1 FILE 618663936(B) 11534336 Extents: 6 Sparse Extents:0 v /dev/vx/rdsk/ramdg/oradata 1 MIRROR 12582912 0 pl vxvm:ramdg/oradata-01 2 STRIPE 12582912 0 Stripe_size:256 rd /dev/vx/rdmp/EMC0_16 2 PARTITION 6291456 0 sd /dev/rhdisk13 2 MIRROR 17846400 0 da EMC000184502242:02:0c:01 0 DISK 143112192 0 da EMC000184502242:31:0c:01 0 DISK 143112192 0 sd /dev/rhdisk41 2 MIRROR 17846400 0 da EMC000184502242:02:0c:01 0 DISK 143112192 0 da EMC000184502242:31:0c:01 0 DISK 143112192 0 rd /dev/vx/rdmp/EMC0_12 2 PARTITION 6291456 0 sd /dev/rhdisk14 2 MIRROR 17846400 0 da EMC000184502242:01:0d:01 0 DISK 143112192 0 da EMC000184502242:32:0d:01 0 DISK 143112192 0 sd /dev/rhdisk42 2 MIRROR 17846400 0 da EMC000184502242:01:0d:01 0 DISK 143112192 0 da EMC000184502242:32:0d:01 0 DISK 143112192 0To print the entire I/O mapping and statistics of each I/O stack:
# /opt/VRTSdbed/bin/vxstorage_stats -m -s -f /data/system01.dbf TY NAME NSUB DESCRIPTION SIZE(sectors) OFFSET(sectors) PROPERTIES fi /oradata/system01.dbf 1 FILE 618663936(B) 11534336 Extents: 6 Sparse Extents:0 v /dev/vx/rdsk/ramdg/oradata 1 MIRROR 12582912 0 pl vxvm:ramdg/oradata-01 2 STRIPE 12582912 0 Stripe_size:256 rd /dev/vx/rdmp/EMC0_16 2 PARTITION 6291456 0 sd /dev/rhdisk13 2 MIRROR 17846400 0 da EMC000184502242:02:0c:01 0 DISK 143112192 0 da EMC000184502242:31:0c:01 0 DISK 143112192 0 sd /dev/rhdisk41 2 MIRROR 17846400 0 da EMC000184502242:02:0c:01 0 DISK 143112192 0 da EMC000184502242:31:0c:01 0 DISK 143112192 0 rd /dev/vx/rdmp/EMC0_12 2 PARTITION 6291456 0 sd /dev/rhdisk14 2 MIRROR 17846400 0 da EMC000184502242:01:0d:01 0 DISK 143112192 0 da EMC000184502242:32:0d:01 0 DISK 143112192 0 sd /dev/rhdisk42 2 MIRROR 17846400 0 da EMC000184502242:01:0d:01 0 DISK 143112192 0 da EMC000184502242:32:0d:01 0 DISK 143112192 0 I/O OPERATIONS I/O BLOCKS(512 byte) AVG TIME(ms) OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR /oradata/system01.dbf 287021 275609 2296504 2898416 2.02 98.02 /dev/vx/rdsk/ramdg/oradata 307856 372064 3690425 6426299 1.98 77.61 vxvm:ramdg/oradata-01 307869 372065 3690529 6426511 1.98 77.61 /dev/rhdisk13 146504 158258 1763433 2966464 2.16 92.61 EMC000184502242:02:0c:01 5546124 15721781 118224296 967486277 - - EMC000184502242:31:0c:01 6024254 15566930 151512680 965106560 - - /dev/rhdisk41 148643 158463 1780545 2985152 2.15 92.49 EMC000184502242:02:0c:01 5546124 15721781 118224296 967486277 - - EMC000184502242:31:0c:01 6024254 15566930 151512680 965106560 - - /dev/rhdisk14 169737 224798 1955720 3535868 2.23 67.45 EMC000184502242:01:0d:01 5330453 13888409 94918220 603917193 - - EMC000184502242:32:0d:01 22612024 30295506 868273331 1326216512 - - /dev/rhdisk42 169737 226953 1955720 3723823 2.23 69.03 EMC000184502242:01:0d:01 5330453 13888409 94918220 603917193 - - EMC000184502242:32:0d:01 22612024 30295506 868273331 1326216512 - -To print statistics two times with a time interval of two seconds:
\$# /opt/VRTSdbed/bin/vxstorage_stats -s -i2 -c2 -f /data/system01.dbf I/O OPERATIONS I/O BLOCKS(512 byte) AVG TIME(ms) OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR /oradata/system01.dbf 287021 275609 2296504 2898416 2.02 98.02 /dev/vx/rdsk/ramdg/oradata 307856 372064 3690425 6426299 1.98 77.61 vxvm:ramdg/oradata-01 307869 372065 3690529 6426511 1.98 77.61 /dev/rhdisk13 146504 158258 1763433 2966464 2.16 92.61 EMC000184502242:02:0c:01 5546124 15721781 118224296 967486277 - - EMC000184502242:31:0c:01 6024254 15566930 151512680 965106560 - - /dev/rhdisk41 148643 158463 1780545 2985152 2.15 92.49 EMC000184502242:02:0c:01 5546124 15721781 118224296 967486277 - - EMC000184502242:31:0c:01 6024254 15566930 151512680 965106560 - - /dev/rhdisk14 169737 224798 1955720 3535868 2.23 67.45 EMC000184502242:01:0d:01 5330453 13888409 94918220 603917193 - - EMC000184502242:32:0d:01 22612024 30295506 868273331 1326216512 - - /dev/rhdisk42 169737 226953 1955720 3723823 2.23 69.03 EMC000184502242:01:0d:01 5330453 13888409 94918220 603917193 - - EMC000184502242:32:0d:01 22612024 30295506 868273331 1326216512 - - I/O OPERATIONS I/O BLOCKS(512 byte) AVG TIME(ms) OBJECT READ WRITE B_READ B_WRITE AVG_RD AVG_WR /oradata/system01.dbf 11917 13102 95336 594402 2.84 278.81 /dev/vx/rdsk/ramdg/oradata 11959 14729 105839 704811 3.11 295.20 vxvm:ramdg/oradata-01 11947 14729 107783 704799 3.14 295.23 /dev/rhdisk13 5974 8366 53663 352207 2.95 246.65 EMC000184502242:02:0c:01 5 733 320 49897 - - EMC000184502242:31:0c:01 1 1230 8 174752 - - /dev/rhdisk41 4705 8249 73526 339740 6.01 250.18 EMC000184502242:02:0c:01 5 733 320 49897 - - EMC000184502242:31:0c:01 1 1230 8 174752 - - /dev/rhdisk14 3895 6264 91672 295491 11.49 279.42 EMC000184502242:01:0d:01 0 0 0 0 - - EMC000184502242:32:0d:01 1 1336 8 190456 - - /dev/rhdisk42 4407 4840 119576 116696 13.12 287.46 EMC000184502242:01:0d:01 0 0 0 0 - - EMC000184502242:32:0d:01 1 1336 8 190456 - -
SEE ALSO
Veritas Storage Foundation for Oracle Administrator's Guide Veritas Storage Foundation for Oracle RAC Installation and Configuration Guide
Veritas Storage Foundation for DB2 Administrator's GuideLast updated: 15 Jan 2006
Copyright ©2009 Symantec Corporation
All rights reserved.