Hello everybody.
I have Oracle 12.1.0.2 two-node RAC.
To be inline with oracle documentation "https://docs.google.com/viewer?a=v&pid=sites&srcid=ZGVmYXVsdGRvbWFpbnxvcmFkYmptfGd4OjQ5NTExMDA5MzViMmQ2NzY" i have to make some tests before installing oracle software onto servers.
So i've managed to conduct orin test for OLTP but i really confused with the results. I need explanation. Also i don't understand how to find out whether my results sufficient or not. So please help to grasp the output of the command below. In addition i provided some pics wich i created from csvs:
$ /u01/app/12.1.0/grid_1/bin/orion -run oltp -testname myorion
ORION: ORacle IO Numbers -- Version 12.1.0.2.0
myorion_20160804_1454
Calibration will take approximately 24 minutes.
Using a large value for -cache_size may take longer.
Maximum Small IOPS=6197 @ Small=33 and Large=0
Small Read Latency: avg=5324 us, min=117 us, max=210661 us, std dev=10703 us @ Small=33 and Large=0
Minimum Small Latency=5279 usecs @ Small=30 and Large=0
Small Read Latency: avg=5279 us, min=102 us, max=239087 us, std dev=10909 us @ Small=30 and Large=0
Small Read / Write Latency Histogram @ Small=30 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: 516 0
128 - 256 us: 122283 0
256 - 512 us: 88262 0
512 - 1024 us: 6233 0
1024 - 2048 us: 5087 0
2048 - 4096 us: 12247 0
4096 - 8192 us: 32649 0
8192 - 16384 us: 39544 0
16384 - 32768 us: 24778 0
32768 - 65536 us: 7766 0
65536 - 131072 us: 1154 0
131072 - 262144 us: 238 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
[grid@test-node1 .scripts]$ ls -al
total 108
drwxr-xr-x 2 grid oinstall 4096 Aug 4 14:54 .
drwx------ 4 grid oinstall 4096 Aug 4 14:37 ..
-rw-r--r-- 1 grid oinstall 0 Aug 4 14:52 myorion_20160804_1452_hist.txt
-rw-r--r-- 1 grid oinstall 0 Aug 4 14:52 myorion_20160804_1452_iops.csv
-rw-r--r-- 1 grid oinstall 0 Aug 4 14:52 myorion_20160804_1452_lat.csv
-rw-r--r-- 1 grid oinstall 0 Aug 4 14:52 myorion_20160804_1452_mbps.csv
-rw-r--r-- 1 grid oinstall 346 Aug 4 14:52 myorion_20160804_1452_summary.txt
-rw-r--r-- 1 grid oinstall 123 Aug 4 14:52 myorion_20160804_1452_trace.txt
-rw-r--r-- 1 grid oinstall 19643 Aug 4 15:14 myorion_20160804_1454_hist.txt
-rw-r--r-- 1 grid oinstall 742 Aug 4 15:14 myorion_20160804_1454_iops.csv
-rw-r--r-- 1 grid oinstall 781 Aug 4 15:14 myorion_20160804_1454_lat.csv
-rw-r--r-- 1 grid oinstall 570 Aug 4 15:14 myorion_20160804_1454_mbps.csv
-rw-r--r-- 1 grid oinstall 1959 Aug 4 15:14 myorion_20160804_1454_summary.txt
-rw-r--r-- 1 grid oinstall 43324 Aug 4 15:14 myorion_20160804_1454_trace.txt
-rw-r--r-- 1 grid oinstall 30 Aug 4 14:38 myorion.lun
[grid@test-node1 .scripts]$ cat myorion_20160804_1454_hist.txt
This file contains histograms of the latencies observed for each data point test.
Each data point test used a fixed number of outstanding small and large I/Os.
For each data point, histograms are printed for the latencies of small reads, small writes, large reads, and large writes.
The bucket sizes of the histogram are specified in microseconds and range from 1 microsecond to 134 seconds.
The value specifies the number of I/Os that were observed within the bucket's latency range.
Latency Histogram for small IOs @ Small=3 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: 0 0
128 - 256 us: 102 0
256 - 512 us: 14747 0
512 - 1024 us: 1688 0
1024 - 2048 us: 148 0
2048 - 4096 us: 416 0
4096 - 8192 us: 2242 0
8192 - 16384 us: 4073 0
16384 - 32768 us: 1916 0
32768 - 65536 us: 890 0
65536 - 131072 us: 254 0
131072 - 262144 us: 34 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
Latency Histogram for small IOs @ Small=6 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: 52 0
128 - 256 us: 8580 0
256 - 512 us: 21862 0
512 - 1024 us: 1861 0
1024 - 2048 us: 442 0
2048 - 4096 us: 1125 0
4096 - 8192 us: 4967 0
8192 - 16384 us: 8097 0
16384 - 32768 us: 4245 0
32768 - 65536 us: 1727 0
65536 - 131072 us: 440 0
131072 - 262144 us: 47 0
262144 - 524288 us: 1 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
Latency Histogram for small IOs @ Small=9 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: 776 0
128 - 256 us: 40034 0
256 - 512 us: 20460 0
512 - 1024 us: 535 0
1024 - 2048 us: 1003 0
2048 - 4096 us: 2803 0
4096 - 8192 us: 9003 0
8192 - 16384 us: 12939 0
16384 - 32768 us: 6686 0
32768 - 65536 us: 2439 0
65536 - 131072 us: 474 0
131072 - 262144 us: 63 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
Latency Histogram for small IOs @ Small=12 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: 663 0
128 - 256 us: 44565 0
256 - 512 us: 28708 0
512 - 1024 us: 819 0
1024 - 2048 us: 1127 0
2048 - 4096 us: 2993 0
4096 - 8192 us: 10026 0
8192 - 16384 us: 15622 0
16384 - 32768 us: 8965 0
32768 - 65536 us: 3493 0
65536 - 131072 us: 782 0
131072 - 262144 us: 120 0
262144 - 524288 us: 2 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
Latency Histogram for small IOs @ Small=15 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: 125 0
128 - 256 us: 53677 0
256 - 512 us: 44653 0
512 - 1024 us: 1268 0
1024 - 2048 us: 1740 0
2048 - 4096 us: 4435 0
4096 - 8192 us: 14254 0
8192 - 16384 us: 20328 0
16384 - 32768 us: 11817 0
32768 - 65536 us: 4180 0
65536 - 131072 us: 733 0
131072 - 262144 us: 108 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
Latency Histogram for small IOs @ Small=18 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: 265 0
128 - 256 us: 65405 0
256 - 512 us: 47686 0
512 - 1024 us: 2783 0
1024 - 2048 us: 3159 0
2048 - 4096 us: 5557 0
4096 - 8192 us: 16078 0
8192 - 16384 us: 23231 0
16384 - 32768 us: 14068 0
32768 - 65536 us: 5088 0
65536 - 131072 us: 947 0
131072 - 262144 us: 200 0
262144 - 524288 us: 1 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
Latency Histogram for small IOs @ Small=21 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: 539 0
128 - 256 us: 81503 0
256 - 512 us: 53083 0
512 - 1024 us: 2274 0
1024 - 2048 us: 2701 0
2048 - 4096 us: 6578 0
4096 - 8192 us: 18731 0
8192 - 16384 us: 26145 0
16384 - 32768 us: 16572 0
32768 - 65536 us: 6255 0
65536 - 131072 us: 1102 0
131072 - 262144 us: 184 0
262144 - 524288 us: 8 0
524288 - 1048576 us: 1 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
Latency Histogram for small IOs @ Small=24 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: 456 0
128 - 256 us: 100944 0
256 - 512 us: 65499 0
512 - 1024 us: 3013 0
1024 - 2048 us: 3286 0
2048 - 4096 us: 8797 0
4096 - 8192 us: 24114 0
8192 - 16384 us: 32030 0
16384 - 32768 us: 19778 0
32768 - 65536 us: 6443 0
65536 - 131072 us: 987 0
131072 - 262144 us: 178 0
262144 - 524288 us: 9 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
Latency Histogram for small IOs @ Small=27 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: 493 0
128 - 256 us: 113431 0
256 - 512 us: 73897 0
512 - 1024 us: 4917 0
1024 - 2048 us: 4619 0
2048 - 4096 us: 10180 0
4096 - 8192 us: 27726 0
8192 - 16384 us: 35272 0
16384 - 32768 us: 22323 0
32768 - 65536 us: 7425 0
65536 - 131072 us: 1037 0
131072 - 262144 us: 209 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
Latency Histogram for small IOs @ Small=30 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: 516 0
128 - 256 us: 122283 0
256 - 512 us: 88262 0
512 - 1024 us: 6233 0
1024 - 2048 us: 5087 0
2048 - 4096 us: 12247 0
4096 - 8192 us: 32649 0
8192 - 16384 us: 39544 0
16384 - 32768 us: 24778 0
32768 - 65536 us: 7766 0
65536 - 131072 us: 1154 0
131072 - 262144 us: 238 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
Latency Histogram for small IOs @ Small=33 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: 12 0
128 - 256 us: 33362 0
256 - 512 us: 160774 0
512 - 1024 us: 35403 0
1024 - 2048 us: 11487 0
2048 - 4096 us: 14443 0
4096 - 8192 us: 36298 0
8192 - 16384 us: 43180 0
16384 - 32768 us: 27442 0
32768 - 65536 us: 7895 0
65536 - 131072 us: 1125 0
131072 - 262144 us: 294 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
Latency Histogram for small IOs @ Small=36 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: 0 0
128 - 256 us: 83 0
256 - 512 us: 44909 0
512 - 1024 us: 121272 0
1024 - 2048 us: 51030 0
2048 - 4096 us: 21362 0
4096 - 8192 us: 33575 0
8192 - 16384 us: 42259 0
16384 - 32768 us: 28118 0
32768 - 65536 us: 9365 0
65536 - 131072 us: 1509 0
131072 - 262144 us: 292 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
Latency Histogram for small IOs @ Small=39 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: 0 0
128 - 256 us: 21 0
256 - 512 us: 18683 0
512 - 1024 us: 91464 0
1024 - 2048 us: 86443 0
2048 - 4096 us: 41878 0
4096 - 8192 us: 36481 0
8192 - 16384 us: 46583 0
16384 - 32768 us: 29976 0
32768 - 65536 us: 9514 0
65536 - 131072 us: 1306 0
131072 - 262144 us: 305 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
Latency Histogram for small IOs @ Small=42 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: 0 0
128 - 256 us: 13 0
256 - 512 us: 7225 0
512 - 1024 us: 41529 0
1024 - 2048 us: 63552 0
2048 - 4096 us: 55761 0
4096 - 8192 us: 37523 0
8192 - 16384 us: 37919 0
16384 - 32768 us: 27265 0
32768 - 65536 us: 13177 0
65536 - 131072 us: 3300 0
131072 - 262144 us: 410 0
262144 - 524288 us: 3 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
Latency Histogram for small IOs @ Small=45 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: 0 0
128 - 256 us: 8 0
256 - 512 us: 8446 0
512 - 1024 us: 45269 0
1024 - 2048 us: 78525 0
2048 - 4096 us: 83012 0
4096 - 8192 us: 52250 0
8192 - 16384 us: 51805 0
16384 - 32768 us: 33673 0
32768 - 65536 us: 10720 0
65536 - 131072 us: 1370 0
131072 - 262144 us: 314 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
Latency Histogram for small IOs @ Small=48 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: 0 0
128 - 256 us: 2 0
256 - 512 us: 5182 0
512 - 1024 us: 31603 0
1024 - 2048 us: 61663 0
2048 - 4096 us: 85226 0
4096 - 8192 us: 64164 0
8192 - 16384 us: 52971 0
16384 - 32768 us: 35423 0
32768 - 65536 us: 11814 0
65536 - 131072 us: 1694 0
131072 - 262144 us: 349 0
262144 - 524288 us: 1 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
Latency Histogram for small IOs @ Small=51 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: 0 0
128 - 256 us: 4 0
256 - 512 us: 3345 0
512 - 1024 us: 20977 0
1024 - 2048 us: 43034 0
2048 - 4096 us: 71614 0
4096 - 8192 us: 73515 0
8192 - 16384 us: 52463 0
16384 - 32768 us: 36861 0
32768 - 65536 us: 14589 0
65536 - 131072 us: 2296 0
131072 - 262144 us: 330 0
262144 - 524288 us: 1 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
Latency Histogram for small IOs @ Small=54 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: 0 0
128 - 256 us: 1 0
256 - 512 us: 3649 0
512 - 1024 us: 21391 0
1