orion的使用

概述

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和 GRIDHOME/binORACLE_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]#
姚远ACE CSDN认证博客专家 ACE 华为云 MVP
Oracle ACE,华为云 MVP,Oracle10g,12c OCM; MySQL 5.6,5.7,8.0 OCP;CCNA; EMC Certified; IBM P Certified; RHCE; SQLServer 764; DB2 Certified; TOEIC 890;获得过两次国家部级科技进步奖;发明过两项计算机专利。微信:yaoyuanace 邮箱:yaoyuanace(at)qq.com
已标记关键词 清除标记
相关推荐
©️2020 CSDN 皮肤主题: Age of Ai 设计师:meimeiellie 返回首页