一、测试软件orion
ORION (Oracle I/O Calibration Tool) 是校准用于 Oracle 数据库的存储系统 I/O 性能的独立工具。校准结果对于了解存储系统的性能有很大帮助,不仅可以找出影响 Oracle 数据库性能的问题,还能测量新数据库安装的大小。由于 ORION 是一个独立工具,用户不需要创建和运行 Oracle 数据库。
为了尽可能地模拟 Oracle 数据库,ORION 使用和 Oracle 相同的 I/O 软件集生成一个合成的 I/O 负载。可以将 ORION 配置为生成很多 I/O 负载,包括一个模拟 OLTP 和数据仓库负载的 I/O 负载。二、测试环境
linux配置
QQ图片20150116092520.jpg (42.84 KB, 下载次数: 0)
2015-1-16 09:25 上传
windows配置:
2.jpg (43.06 KB, 下载次数: 0)
2015-1-16 09:29 上传
三、实际测试对比:
1、测试命令:
./orion -run simple -testname mytest -num_disks 1
2、linux测试结果:
[root@rac2 ~]# cat mytest_20150115_0849_summary.txt
ORION VERSION 11.1.0.7.0
Commandline:
-run simple -testname mytest -num_disks 1
This maps to this test:
Test: mytest
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:, 0
Large Columns:, 0, 1, 2
Total Data Points: 8
Name: /dev/sda2 Size: 107265876480
1 FILEs found.
Maximum Large MBPS=1326.73 @ Small=0 and Large=2
Maximum Small IOPS=12990 @ Small=5 and Large=0
Minimum Small Latency=0.34 @ Small=2 and Large=0
3、windows测试结果:
ORION VERSION 10.2.0.1.0
Commandline:
-run simple -testname li -num_disks 1
This maps to this test:
Test: li
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Random IOs
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:, 0
Large Columns:, 0, 1, 2
Total Data Points: 8
Name: \\.\C: Size: 4188012544
1 FILEs found.
Maximum Large MBPS=749.34 @ Small=0 and Large=2
Maximum Small IOPS=3874 @ Small=5 and Large=0
Minimum Small Latency=1.17 @ Small=1 and Large=0
linux测试结果为12990,Windows测试结果3874,综上所述同等配置,linux下的IOPS值为windows的3.35倍。