概述
Orion是oracle提供的测试io性能的工具。它可以用来模拟Oracle数据库IO,也可以用来仿真ASM的条带化的功能,性能指标包括:IOPS,MBPS,Latency(延迟时间)。从Oracle Database 11g开始,Orion工具被集成到GI和Database软件中,所以在G R I D H O M E / b i n 和 GRID_HOME/bin和GRID
H
OME/bin和ORACLE_HOME/bin目录下都可以找到这个工具。
简单测试案例
simple测试,这个默认是只读,7个SSD的盘,性能还不错吧。
[oracle@localhost orion]$ sudo /u01/app/oracle/product/11.2.0/dbhome_1/bin/orion -run simple -testname local -num_disks 7 ORION: ORacle IO Numbers -- Version 11.2.0.4.0 local_20200407_1829 Calibration will take approximately 51 minutes. Using a large value for -cache_size may take longer. Maximum Large MBPS=2791.33 @ Small=0 and Large=14 Maximum Small IOPS=109807 @ Small=34 and Large=0 Small Read Latency: avg=309 us, min=83 us, max=18943 us, std dev=201 us @ Small=34 and Large=0 Minimum Small Latency=104 usecs @ Small=1 and Large=0 Small Read Latency: avg=104 us, min=59 us, max=18554 us, std dev=101 us @ Small=1 and Large=0 Small Read / Write Latency Histogram @ Small=1 and Large=0 Latency: # of IOs (read) # of IOs (write) 0 - 1 us: 0 0 2 - 4 us: 0 0 4 - 8 us: 0 0 8 - 16 us: 0 0 16 - 32 us: 0 0 32 - 64 us: 30541 0 64 - 128 us: 321662 0 128 - 256 us: 224241 0 256 - 512 us: 81 0 512 - 1024 us: 104 0 1024 - 2048 us: 3 0 2048 - 4096 us: 0 0 4096 - 8192 us: 8 0 8192 - 16384 us: 6 0 16384 - 32768 us: 10 0 32768 - 65536 us: 0 0 65536 - 131072 us: 0 0 131072 - 262144 us: 0 0 262144 - 524288 us: 0 0 524288 - 1048576 us: 0 0 1048576 - 2097152 us: 0 0 2097152 - 4194304 us: 0 0 4194304 - 8388608 us: 0 0 8388608 - 16777216 us: 0 0 16777216 - 33554432 us: 0 0 33554432 - 67108864 us: 0 0 67108864 - 134217728 us: 0 0 134217728 - 268435456 us: 0 0
加上写的参数 write,注意对应的所有数据都会被清除。
写测试
创建一个100g的测试文件
[oracle@dell fc-0x21000024FF12C99A-lun-1]$ dd if=/dev/zero of=orion_test1 bs=1M count=102400 102400+0 records in 102400+0 records out 107374182400 bytes (107 GB) copied, 85.3683 s, 1.3 GB/s [oracle@dell fc-0x21000024FF12C99A-lun-1]$ ls -lh orion_test1 -rw-r--r--. 1 oracle oinstall 100G Dec 21 10:08 orion_test1 [oracle@dell fc-0x21000024FF12C99A-lun-1]$
测试一下这个文件是否可以用:
dd if=/mnt/ddf1eeae796a11ea8000b4055d019826/acbfbe42797211ea8000b4055d019826_lun_1/orion_test bs=32k count=1024
编辑测试案例对应的lun文件,把 “/mnt/ddf1eeae796a11ea8000b4055d019826/acbfbe42797211ea8000b4055d019826_lun_1/orion_test ” 加入。
直接把simple的测试方式加上 -write 100 (就是100%的写,不读)不行:
[oracle@localhost orion]$ sudo /u01/app/oracle/product/11.2.0/dbhome_1/bin/orion -run simple -write 100 -testname zfs8K_10Ge -num_disks 24 ORION: ORacle IO Numbers -- Version 11.2.0.4.0 ERROR: When -run is simple or normal, -testname and -num_disks must be specified. The only other parameters which may be specified are -cache_size, -storax, -hugenotneeded and -verbose.
采用advanced方式,重新编辑:
sudo /u01/app/oracle/product/11.2.0/dbhome_1/bin/orion -run advanced -testname \ zfs8K_10Ge -num_disks 24 -size_small 8 -size_large 1024 -type rand -simulate \ concat -write 100 -duration 60 -matrix basic
Orion 运行出错的排除
ORION: ORacle IO Numbers -- Version RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417 WARNING: Huge pages are not configured, run ORION command with "-hugenotneeded" Failed to create shared memory (orion_setup_shmem:skgmcreate) Additional information: 6122 Additional information: 1 orion_parse_args: orion_setup_shmem failed [oracle@dell fc-0x21000024FF12C99A-lun-1]$ sudo echo 100 >/proc/sys/vm/nr_hugepages -bash: /proc/sys/vm/nr_hugepages: Permission denied [oracle@dell fc-0x21000024FF12C99A-lun-1]$ su Password: [root@dell fc-0x21000024FF12C99A-lun-1]# echo 100 >/proc/sys/vm/nr_hugepages [root@dell fc-0x21000024FF12C99A-lun-1]#