ORACLE ORION Tests IO Performance

https://www.oracle.com/technetwork/cn/topics/index-088165-zhs.html Download address

Orion is an IO performance testing tool provided by Oracle. It does not need to install oracle database software or create database to run this tool. It can simulate the IO load of oracle database, and it can also be used to simulate the striping function of ASM.

After downloading, decompression can be used directly.

Write the device to be tested into a file on the same path, and then test it.

[root@localhost oracle]# cat mytest.lun 
/dev/mapper/ol-root
[root@localhost oracle]# ./orion_linux_x86-64 -run simple -testname mytest -num_disks 1
ORION: ORacle IO Numbers -- Version 11.1.0.7.0
mytest_20190329_1057
Test will take approximately 9 minutes
Larger caches may take longer

[root@localhost oracle]# ls|grep csv
mytest_20190329_1057_iops.csv
mytest_20190329_1057_lat.csv
mytest_20190329_1057_mbps.csv
[root@localhost oracle]# cat mytest_20190329_1057_iops.csv 
Large/Small,      1,      2,      3,      4,      5
          0,   2302,   4398,   5450,   6006,   6210
          1
          2
[root@localhost oracle]# cat mytest_20190329_1057_lat.csv 
Large/Small,      1,      2,      3,      4,      5
          0,   0.43,   0.45,   0.55,   0.67,   0.80
          1
          2
[root@localhost oracle]# cat mytest_20190329_1057_mbps.csv 
Large/Small,      0,      1,      2,      3,      4,      5
          1, 271.58
          2, 374.26
[root@localhost oracle]#
[root@localhost oracle]# ll|grep mytest
-rw-r--r--. 1 root   root          128 Mar 29 11:04 mytest_20190329_1057_iops.csv
-rw-r--r--. 1 root   root          128 Mar 29 11:04 mytest_20190329_1057_lat.csv
-rw-r--r--. 1 root   root          100 Mar 29 11:04 mytest_20190329_1057_mbps.csv
-rw-r--r--. 1 root   root          599 Mar 29 11:04 mytest_20190329_1057_summary.txt
-rw-r--r--. 1 root   root         2969 Mar 29 11:04 mytest_20190329_1057_trace.txt
-rw-r--r--. 1 root   root           20 Mar 29 10:57 mytest.lun
[root@localhost oracle]# cat mytest_20190329_1057_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/mapper/ol-root       Size: 49178214400
1 FILEs found.

Maximum Large MBPS=374.26 @ Small=0 and Large=2
Maximum Small IOPS=6210 @ Small=5 and Large=0
Minimum Small Latency=0.43 @ Small=1 and Large=0

At the end of the session, there will be five more files, namely test details, profiles, iops, mbps, latency.

Keywords: Oracle Database iOS Session

Added by Hell Toupee on Fri, 04 Oct 2019 20:37:08 +0300