ORION 11.2.0.3 - Oracle I/O Numbers

11g database has included officialy unsupported tool for storage IO measurement. Can be found in $ORACLE_HOME/bin, release of which is similar to DB release. There is almost no official information about Orion 11.2.0.3 neither MOS or documentation. What is the point to use this tool? Well, first of all is - Orion makes IO workload similar to database workload, i.e can make OLTP, DSS ( OLAP\DWH systems) or mixed workload with the same block size as database load. Another reason is - although tool
is unsupported - it's developed by Oracle from release to release, so I think it will be ever supported. It can run in 5 modes:

• oltp - loads small IOs only ( 2-32K, default 8kb)
• dss - loads large IOs only (>=128kb, default 1m)
• normal - variable combination of 8kb and 1m workload
• simple - small IOs workload, then large IOs workload 
• advanced - complex workload based on election matrix, which defining mix and interferention of small and large IOs.

Be carefully, by default orion just READ data, but with "-write" key it's going to WRITE data to mount points and ERASE all existing data. Be carefully(!). I'm going to read only. So, we need to create file with list of mount points which we want to test:

[oracle@test.local orion]$ mount |awk '{print $1}'|grep /dev/mapper > mytest.lun

[oracle@test.local orion]$ cat mytest.lun
/dev/mapper/dl-sdb01
/dev/mapper/dl-sdb02
[oracle@test.local orion]$ sudo ./orion -run oltp -testname mytest -num_disks 24 -duration 30
All time in microseconds(us) =1/1000000 sec. Unfortunatly there is an issue to test in NORMAL or ADVANCED mode. Key "-duration", does work only in SIMPLE,OLTP and DSS modes,so. Default duration is 60seconds per "one point sample", so in ADVANCED mode - its about 24(oltp)*24(dss)*60sec= ~9hours.I dont't have so much time, so   I tested OLTP (24*30=~12minutes)
The output log would be:

ORION VERSION 11.2.0.3.0
Command line:
-run oltp -testname mytest -num_disks 24 -duration 30 
These options enable these settings:
Test: mytest
Small IO size: 8 KB
Large IO size: 1024 KB
IO types: small random IOs, large random IOs
Sequential stream pattern: one LUN per stream 
Writes: 0%
Cache size: not specified
Duration for each data point: 30 seconds
Small Columns:,     24,     48,     72,     96,    120,    144,    168,    192,    216,    240,    264,    288,    312,    336,    360,    384,    408,    432,    456,    480
Large Columns:,      0
Total Data Points: 44
Name: /dev/mapper/dl-sdb01 Size: 1247999950848
Name: /dev/mapper/dl-sdb02 Size: 1498416087040
2 files found.
Maximum Small IOPS=5321 @ Small=480 and Large=0
Small Read Latency: avg=90199 us, min=40826 us, max=599406 us, std dev=29438 us @ Small=480 and Large=0
Minimum Small Latency=7640.00 usecs @ Small=24 and Large=0
Small Read Latency: avg=7640 us, min=114 us, max=110447 us, std dev=4834 us @ Small=24 and Large=0
Small Read / Write Latency Histogram @ Small=480 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: 43 0
      128 - 256 us: 48 0
      256 - 512 us: 13 0
      512 - 1024 us: 5 0
     1024 - 2048 us: 1419 0
     2048 - 4096 us: 28472 0
     4096 - 8192 us: 101814 0
     8192 - 16384 us: 46385 0
    16384 - 32768 us: 9416 0
    32768 - 65536 us: 709 0
    65536 - 131072 us: 12 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