A simple test of orion

A simple test of orion

Orion is a small I/O testing tool that can test random read/write and simulate mixed loads. This tool is already included in Oracle 11g, and does not need to be installed any more. It has brought a lot of convenience for I/O testing.

Of course, I still encountered some minor problems when using such a simple tool. A brief summary.
First, use orion to directly prompt the dependency Library
[Oracle @ db117 bin] $ orion
Orion: error while loading shared libraries: libclntsh. so.11.1: cannot open shared object file: No such file or directory
Because this database is newly installed, I feel that cloning and installation are not properly initialized, but it is still related to the variable LD_LIBRARY_PATH.
Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/usr/X11R6/lib:/usr/local/lib
Add environment variables.
[Oracle @ db117 ~] $ Orion
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
Error in input parameters. For help, run: orion-help.
Orion is officially enabled in this way, just like sqlplus, it is a small tool of $ ORACLE_HOME/bin.
The test environment is as follows, using a mechanical hard disk.
[Oracle @ db117 ~] $ Df-h
Filesystem Size Used Avail Use % Mounted on
/Dev/sda5 9.9 GB 2.4G 7.0G 26%/
Tmpfs 32G 0 32G 0%/dev/shm
/Dev/sda1 388 M 62 M 307 M 17%/boot
/Dev/sda6 1.1 T 92G 908G 10%/home
/Dev/sda2 20G 344 M 19G 2%/var
When using orion, You need to define a file ending with. lun. For example, iotest. lun
The device we want to test is/dev/sda6. Write this device in iotest. lun.
You can try to enable the parameter value corresponding to testname in the following way: iotest
Orion-run oltp-testname iotest
Of course, there are some tips for using this command. For example, if it is directly enabled, the following error will occur.
[Oracle @ db117 temp] $ orion-run oltp-testname iotest
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
* ********************** Large Pages Information ************* ******
Parameter use_large_pages = onlyPer process system memlock (soft) limit = 64 KB
Large Pages unused system wide = 0 (0 KB)
Large Pages configured system wide = 0 (0 KB)
Large Page size = 2048 KB
ERROR:
Failed to allocate shared global region with large pages, unix errno = 1.
Aborting the run of Orion. ORA-27137: unable to allocate Large Pages to create a shared memory segment
ACTION:
1. Check the permission to access system large pages.
2. Large pages are automatically locked into physical memory.
Increase the per process memlock (soft) limit to at least 8192 KB to lock
100% Orion I/O Buf Area's large pages into physical memory
**************************************** ***************************
Increase huge pages as suggested or set-hugenotneeded flag on command line
Failed to create shared memory of size 1051296 (orion_setup_shmem: skgmcreate)
Linux-x86_64 Error: 1: Operation not permitted
Additional information: 2097152
Orion_parse_args: orion_setup_shmem failed
Of course, the prompt information is already obvious. The current environment does not have a large page configured, so you still need to configure a large page or declare that a large page is not required.
You can use hugenotneeded to declare it. Of course there are still some minor problems.
[Oracle @ db117 temp] $ orion-run simple-testname iotest-hugenotneeded
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
Iotest_20160420_1609
Calibration will take approximately 9 minutes.
Using a large value for-cache_size may take longer.

ORA-56727: orion must be invoked using its full, absolute path
Orion_main: orion_spawn sml failed
Test aborted due to errors.
This command requires the full path. Do not use the relative path. Change it to the full path to continue the test.
[Oracle @ db117 temp] $ ORACLE_HOME/bin/orion-run simple-testname iotest-hugenotneeded
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
Iotest_20160420_1610
Calibration will take approximately 9 minutes.
Using a large value for-cache_size may take longer.

Error identifying file/dev/sda6 (storax_skgfr_openfiles: skgfifi)
ORA-27041: see Oracle documentation for information on error
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
Test aborted due to errors.
At this time, the prompt is that the permission is insufficient. The oracle user in use does not have a higher permission to operate on/dev/sda6. Therefore, you can adjust the permission or directly run it using root.
Run the dd command to test whether/dev/sda6 is available.
[Root @ db117 ~] # Dd if =/dev/sda6 of =/dev/null bs = 32 k count = 1024
1024 + 0 records in
1024 + 0 records out
33554432 bytes (34 MB) copied, 0.052941 s, 634 MB/s
Of course, you can use orion to initialize the environment variables in. bash_profile under the oracle user to the root user.
If you want to give it a simple try, you can use the following command. The generated test time cannot be changed. After a simple wait, the output is as follows:
[Root @ db117 temp] #/U01/app/oracle/product/11.2.0.4/bin/orion-run simple-testname iotest-hugenotneeded
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
Iotest_20160420_1631
Calibration will take approximately 9 minutes.
Using a large value for-cache_size may take longer.
Maximum Large MBPS = 210.16 @ Small = 0 and Large = 2
Maximum Small IOPS = 894 @ Small = 5 and Large = 0
Small Read Latency: avg = 5591 us, min = 32 us, max = 35791 us, std dev = 2949 us @ Small = 5 and Large = 0
Minimum Small Latency = 4320 usecs @ Small = 1 and Large = 0
Small Read Latency: avg = 4320 us, min = 78 us, max = 18253 us, std dev = 1378 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: 0 0
64-128 us: 11 0
128-256 us: 0 0
256-512 us: 0 0
512-1024 us: 2 0
1024-2048 us: 538 0
2048-4096 us: 5625 0
4096-8192 us: 7680 0
8192-16384 us: 22 0
16384-32768 us: 1 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
You can also use the oltp option for testing.
/U01/app/oracle/product/11.2.0.4/bin/orion-run oltp-testname iotest-hugenotneeded
[Root @ db117 temp] #/U01/app/oracle/product/11.2.0.4/bin/orion-run oltp-testname iotest-hugenotneeded
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
Iotest_20160420_1641
Calibration will take approximately 22 minutes.
Using a large value for-cache_size may take longer.
Maximum Small IOPS = 1940 @ Small = 20 and Large = 0
Small Read Latency: avg = 10305 us, min = 42 us, max = 209322 us, std dev = 8938 us @ Small = 20 and Large = 0
Minimum Small Latency = 4311 usecs @ Small = 1 and Large = 0
Small Read Latency: avg = 4311 us, min = 58 us, max = 16964 us, std dev = 1376 us @ Small = 1 and Large = 0
Small Read/Write Latency Histogram @ Small = 1 and Large = 0

Or test random read/write of 8 K
/U01/app/oracle/product/11.2.0.4/bin/orion-run advanced-num_large 0-size_small 8-type rand-simulate raid0-write 0-duration 10-matrix row-testname iotest
[Root @ db117 temp] #/U01/app/oracle/product/11.2.0.4/bin/orion-run advanced-num_large 0-size_small 8-type rand-simulate raid0-write 0- duration 10-matrix row-testname iotest
ORION: ORacle IO Numbers -- Version 11.2.0.4.0
Iotest_20160420_1708
Calibration will take approximately 2 minutes.
Using a large value for-cache_size may take longer.
Maximum Small IOPS = 895 @ Small = 5 and Large = 0
Small Read Latency: avg = 5581 us, min = 55 us, max = 41177 us, std dev = 2968 us @ Small = 5 and Large = 0