Shulou(Shulou.com)06/01 Report--

How to carry out the simple test of orion, in view of this problem, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and feasible method.

Orion is a small tool for IO testing, which can test random reads and writes, simulate mixed loads, and so on.

This tool is already included in oracle 11g without additional installation, which brings a lot of convenience for IO testing.

Of course, I still encountered some minor problems when using such a simple gadget. To sum up briefly.

The first is to use orion to directly prompt the problem of relying on linked libraries.

[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 the database is newly installed, it feels like the clone installation is not initialized, but it is found to have something to do with the variable LD_LIBRARY_PATH.

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/lib:/usr/X11R6/lib:/usr/local/lib

Add environment variables and you can do it right away.

[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 launched, just like sqlplus, which is a $ORACLE_HOME/bin gadget.

The environment we tested is as follows, using a mechanical hard disk.

[oracle@db117] $df-h

Filesystem Size Used Avail Use% Mounted on

/ dev/sda5 9.9G 2.4G 7.0G 26% /

Tmpfs 32G 0 32G 0 0 / dev/shm

/ dev/sda1 388M 62M 307M 17% / boot

/ dev/sda6 1.1T 92G 908G 10% / home

/ dev/sda2 20G 344m 19G 2% / var

When using orion, you need to define a file that ends with .lun. Like iotest.lun.

The device we want to test is / dev/sda6, just write this device in iotest.lun.

You can use the following ways to try to enable testname corresponding to the parameter value is iotest

Orion-run oltp-testname iotest

Of course, there are some tricks for using this command, such as enabling it directly, there will be the following errors.

[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 Dot 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 message is already obvious. There are no large pages configured in the current environment, so you still need to configure large pages or declare that you do not need large pages.

You can use hugenotneeded to declare, of course, there are 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 that you use the full path, not the relative path, and change it to the full path to continue testing.

[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 hint is that the permissions are insufficient, and the original oracle user does not have higher permissions to operate / dev/sda6, so you can adjust the permissions or run it directly using root.

Use the dd command to test whether / dev/sda6 is available.

[root@db117 ~] # dd if=/dev/sda6 of=/dev/null bs=32k count=1024

1024000 records in

1024000 records out

33554432 bytes (34 MB) copied, 0.052941 s, 634 MB/s

Of course, initialize the environment variables in the. bash_profile under the oracle user to the root user, and you can use orion

If you want to give it a try, you can use the following command, and the generated test time cannot be changed. After a simple wait, the simple report of 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

128256 us: 0 0

256512 us: 0

512-1024 us: 2

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

Of course, you can also use oltp's options to test

/ 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 the random read and write of 8k

/ 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

This is the answer to the simple test question on how to conduct orion. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel to learn more about it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.