{"id":153,"date":"2011-05-13T14:48:07","date_gmt":"2011-05-13T12:48:07","guid":{"rendered":"http:\/\/jal-bs.de\/blog\/?p=153"},"modified":"2013-03-27T13:20:14","modified_gmt":"2013-03-27T12:20:14","slug":"io-testing-mit-orion","status":"publish","type":"post","link":"https:\/\/jal-bs.de\/blog\/?p=153","title":{"rendered":"I\/O Testing mit „orion“"},"content":{"rendered":"

Die Performance einer Datenbank wird entscheidend gepr\u00e4gt von dem I\/O Verhalten des Platten-Subsystems.<\/p>\n

Mit Oracle 11gR2 wird standardm\u00e4ssig das Werkzeug \u201eorion\u201c mit installiert.<\/p>\n

Beschrieben ist \u201eorion\u201c im Oracle Performance Tunig Guide Kapitel 8.<\/p>\n

\u201eorion\u201c erlaubt eine Vorhersage der I\/O Performance ohne eine Datenbank zu installieren und eignet sich so, vorab Platten-Subsystems zu analysieren.<\/p>\n

Die ermitteln Informationen werden u. a. in ein *.csv File abgelegt, dass in Excel eine graphische Darstellung erlaubt.<\/p>\n

Beispiel:<\/strong><\/p>\n

[oracle]:> cat \/tmp\/o.lun<\/address>\n
\/oracle\/disk01\/control01.ctl\u00a0<\/address>\n
\u00a0<\/address>\n
\u00a0<\/address>\n
[oracle]:> $ORACLE_HOME\/bin\/orion -testname \/tmp\/o -run normal<\/address>\n
ORION: ORacle IO Numbers — Version 11.2.0.1.0
\n\/tmp\/o_20110513_1052
\nCalibration will take approximately 19 minutes.<\/address>\n
Using a large value for -cache_size may take longer.<\/address>\n
\u00a0<\/address>\n
\u00a0[oracle]:> more \/tmp\/o_20110513_1052_mbps.csv \/tmp\/o_20110513_1052_lat.csv
\n::::::::::::::
\n\/tmp\/o_20110513_1052_mbps.csv
\n::::::::::::::
\nLarge\/Small, 0, 1, 2, 3, 4, 5
\n1, 1086.52, 101.61, 109.67, 163.55, 119.99, 113.40
\n2, 987.82, 114.27, 92.76, 155.87, 141.91, 114.85
\n::::::::::::::
\n\/tmp\/o_20110513_1052_lat.csv
\n::::::::::::::
\nLarge\/Small, 1, 2, 3, 4, 5
\n0, 1029.84, 1963.78, 2775.70, 3455.02, 4050.37
\n1, 511.23, 1207.35, 2093.45, 2952.65, 3667.30
\n2, 616.09, 1344.66, 1538.38, 2122.24, 3463.90<\/address>\n
\u00a0<\/address>\n
\u00a0<\/address>\n
[oracle]:> \u00a0more \/tmp\/o_20110513_1052_summary.txt
\nORION VERSION 11.2.0.1.0\u00a0<\/address>\n
Command line:<\/address>\n
-testname \/tmp\/o -run normal<\/address>\n
These options enable these settings:<\/address>\n
Test: \/tmp\/o<\/address>\n
Small IO size: 8 KB<\/address>\n
Large IO size: 1024 KB<\/address>\n
IO types: small random IOs, large random IOs<\/address>\n
Sequential stream pattern: one LUN per stream<\/address>\n
Writes: 0%<\/address>\n
Cache size: not specified<\/address>\n
Duration for each data point: 60 seconds<\/address>\n
Small Columns:, 0, 1, 2, 3, 4, 5<\/address>\n
Large Columns:, 0, 1, 2<\/address>\n
Total Data Points: 18<\/address>\n
\u00a0<\/address>\n
Name: \/oracle\/disk01\/control01.ctl Size: 18399232<\/address>\n
1 files found.<\/address>\n
\u00a0<\/address>\n
Maximum Large MBPS=1086.52 @ Small=0 and Large=1<\/address>\n
Maximum Small IOPS=1954 @ Small=1 and Large=1<\/address>\n
Minimum Small Latency=511.23 usecs @ Small=1 and Large=1<\/address>\n
[oracle]:> more \/tmp\/o_20110513_1052_trace.txt<\/address>\n
\u00a0<\/address>\n
\u00a0<\/address>\n
TEST START<\/address>\n
\u00a0<\/address>\n
Point 1 (small=0, large=0) of 403<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
Point 2 (small=1, large=0) of 403<\/address>\n
Valid small -2 Valid large 1<\/address>\n
\u00a0<\/address>\n
\u00a0<\/address>\n
TEST START<\/address>\n
\u00a0<\/address>\n
Point 1 (small=0, large=0) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 1029.84 us Count = 58193<\/address>\n
ran (small): nio=58193 nior=58193 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 1 oth 0 iops 970 lat 1029.84 us bw = 7.58 MBps dur 59.96 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
Point 2 (small=1, large=0) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 1963.78 us Count = 30542<\/address>\n
ran (small): Index = 1 Avg Lat = 1963.77 us Count = 30542<\/address>\n
ran (small): nio=61084 nior=61084 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 2 oth 0 iops 1018 lat 1963.78 us bw = 7.95 MBps dur 59.99 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
Point 3 (small=2, large=0) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 2775.72 us Count = 21607<\/address>\n
ran (small): Index = 1 Avg Lat = 2775.70 us Count = 21607<\/address>\n
ran (small): Index = 2 Avg Lat = 2775.67 us Count = 21606<\/address>\n
ran (small): nio=64820 nior=64820 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 3 oth 0 iops 1080 lat 2775.70 us bw = 8.44 MBps dur 59.98 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
Point 4 (small=3, large=0) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 3455.00 us Count = 17358<\/address>\n
ran (small): Index = 1 Avg Lat = 3455.01 us Count = 17358<\/address>\n
ran (small): Index = 2 Avg Lat = 3455.03 us Count = 17358<\/address>\n
ran (small): Index = 3 Avg Lat = 3455.02 us Count = 17358<\/address>\n
ran (small): nio=69432 nior=69432 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 4 oth 0 iops 1157 lat 3455.02 us bw = 9.04 MBps dur 59.98 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
Point 5 (small=4, large=0) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 4050.53 us Count = 14806<\/address>\n
ran (small): Index = 1 Avg Lat = 4050.55 us Count = 14806<\/address>\n
ran (small): Index = 2 Avg Lat = 4050.20 us Count = 14805<\/address>\n
ran (small): Index = 3 Avg Lat = 4050.30 us Count = 14805<\/address>\n
ran (small): Index = 4 Avg Lat = 4050.29 us Count = 14805<\/address>\n
ran (small): nio=74027 nior=74027 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 5 oth 0 iops 1234 lat 4050.37 us bw = 9.64 MBps dur 59.97 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
Point 6 (small=5, large=0) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 919.87 us Count = 65158<\/address>\n
ran (large): nio=65158 nior=65158 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 1 oth 0 iops 1086 lat 919.87 us bw = 1086.52 MBps dur 59.97 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 7 (small=0, large=1) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 511.23 us Count = 117252<\/address>\n
ran (small): nio=117252 nior=117252 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 1 oth 1 iops 1954 lat 511.23 us bw = 15.27 MBps dur 60.00 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 9840.80 us Count = 6094<\/address>\n
ran (large): nio=6094 nior=6094 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 1 oth 1 iops 101 lat 9840.80 us bw = 101.61 MBps dur 59.98 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 8 (small=1, large=1) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 1207.34 us Count = 49671<\/address>\n
ran (small): Index = 1 Avg Lat = 1207.35 us Count = 49670<\/address>\n
ran (small): nio=99341 nior=99341 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 2 oth 1 iops 1655 lat 1207.35 us bw = 12.94 MBps dur 59.99 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 9117.87 us Count = 6576<\/address>\n
ran (large): nio=6576 nior=6576 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 1 oth 2 iops 109 lat 9117.87 us bw = 109.67 MBps dur 59.96 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 9 (small=2, large=1) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 2093.42 us Count = 28651<\/address>\n
ran (small): Index = 1 Avg Lat = 2093.45 us Count = 28650<\/address>\n
ran (small): Index = 2 Avg Lat = 2093.47 us Count = 28650<\/address>\n
ran (small): nio=85951 nior=85951 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 3 oth 1 iops 1432 lat 2093.45 us bw = 11.19 MBps dur 59.99 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 6113.83 us Count = 9807<\/address>\n
ran (large): nio=9807 nior=9807 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 1 oth 3 iops 163 lat 6113.83 us bw = 163.55 MBps dur 59.96 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 10 (small=3, large=1) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 2952.92 us Count = 20268<\/address>\n
ran (small): Index = 1 Avg Lat = 2952.93 us Count = 20268<\/address>\n
ran (small): Index = 2 Avg Lat = 2952.58 us Count = 20268<\/address>\n
ran (small): Index = 3 Avg Lat = 2952.17 us Count = 20267<\/address>\n
ran (small): nio=81071 nior=81071 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 4 oth 1 iops 1354 lat 2952.65 us bw = 10.58 MBps dur 59.84 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 8039.69 us Count = 7204<\/address>\n
ran (large): nio=7204 nior=7204 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 1 oth 4 iops 119 lat 8039.69 us bw = 119.99 MBps dur 60.04 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 11 (small=4, large=1) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 3667.29 us Count = 16338<\/address>\n
ran (small): Index = 1 Avg Lat = 3667.25 us Count = 16338<\/address>\n
ran (small): Index = 2 Avg Lat = 3667.32 us Count = 16337<\/address>\n
ran (small): Index = 3 Avg Lat = 3667.32 us Count = 16337<\/address>\n
ran (small): Index = 4 Avg Lat = 3667.34 us Count = 16337<\/address>\n
ran (small): nio=81687 nior=81687 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 5 oth 1 iops 1363 lat 3667.30 us bw = 10.65 MBps dur 59.92 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 8702.64 us Count = 6807<\/address>\n
ran (large): nio=6807 nior=6807 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 1 oth 5 iops 113 lat 8702.64 us bw = 113.40 MBps dur 60.03 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 12 (small=5, large=1) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 2024.09 us Count = 29632<\/address>\n
ran (large): Index = 1 Avg Lat = 2024.18 us Count = 29631<\/address>\n
ran (large): nio=59263 nior=59263 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 2 oth 0 iops 987 lat 2024.14 us bw = 987.82 MBps dur 59.99 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 13 (small=0, large=2) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 616.09 us Count = 97301<\/address>\n
ran (small): nio=97301 nior=97301 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 1 oth 2 iops 1621 lat 616.09 us bw = 12.67 MBps dur 59.99 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 17113.45 us Count = 3429<\/address>\n
ran (large): Index = 1 Avg Lat = 17117.93 us Count = 3428<\/address>\n
ran (large): nio=6857 nior=6857 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 2 oth 1 iops 114 lat 17115.69 us bw = 114.27 MBps dur 60.01 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 14 (small=1, large=2) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 1344.66 us Count = 44575<\/address>\n
ran (small): Index = 1 Avg Lat = 1344.66 us Count = 44574<\/address>\n
ran (small): nio=89149 nior=89149 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 2 oth 2 iops 1486 lat 1344.66 us bw = 11.62 MBps dur 59.96 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 21513.83 us Count = 2784<\/address>\n
ran (large): Index = 1 Avg Lat = 21513.99 us Count = 2784<\/address>\n
ran (large): nio=5568 nior=5568 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 2 oth 2 iops 92 lat 21513.91 us bw = 92.76 MBps dur 60.02 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 15 (small=2, large=2) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 1538.37 us Count = 38983<\/address>\n
ran (small): Index = 1 Avg Lat = 1538.39 us Count = 38983<\/address>\n
ran (small): Index = 2 Avg Lat = 1538.39 us Count = 38983<\/address>\n
ran (small): nio=116949 nior=116949 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 3 oth 2 iops 1949 lat 1538.38 us bw = 15.23 MBps dur 59.99 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 12383.15 us Count = 4677<\/address>\n
ran (large): Index = 1 Avg Lat = 12386.13 us Count = 4677<\/address>\n
ran (large): nio=9354 nior=9354 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 2 oth 3 iops 155 lat 12384.64 us bw = 155.87 MBps dur 60.01 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 16 (small=3, large=2) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 2122.28 us Count = 28254<\/address>\n
ran (small): Index = 1 Avg Lat = 2122.31 us Count = 28254<\/address>\n
ran (small): Index = 2 Avg Lat = 2122.32 us Count = 28253<\/address>\n
ran (small): Index = 3 Avg Lat = 2122.06 us Count = 28253<\/address>\n
ran (small): nio=113014 nior=113014 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 4 oth 2 iops 1884 lat 2122.24 us bw = 14.72 MBps dur 59.97 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 13678.64 us Count = 4258<\/address>\n
ran (large): Index = 1 Avg Lat = 13678.83 us Count = 4258<\/address>\n
ran (large): nio=8516 nior=8516 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 2 oth 4 iops 141 lat 13678.73 us bw = 141.91 MBps dur 60.01 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 17 (small=4, large=2) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
ran (small): VLun = 0 Size = 18399232<\/address>\n
ran (small): Index = 0 Avg Lat = 3464.10 us Count = 17309<\/address>\n
ran (small): Index = 1 Avg Lat = 3464.15 us Count = 17308<\/address>\n
ran (small): Index = 2 Avg Lat = 3463.77 us Count = 17308<\/address>\n
ran (small): Index = 3 Avg Lat = 3463.76 us Count = 17308<\/address>\n
ran (small): Index = 4 Avg Lat = 3463.75 us Count = 17308<\/address>\n
ran (small): nio=86541 nior=86541 niow=0 req w%=0 act w%=0<\/address>\n
ran (small): my 5 oth 2 iops 1443 lat 3463.90 us bw = 11.28 MBps dur 59.96 s size 8 K READ<\/address>\n
\u00a0<\/address>\n
ran (large): VLun = 0 Size = 18399232<\/address>\n
ran (large): Index = 0 Avg Lat = 17285.78 us Count = 3448<\/address>\n
ran (large): Index = 1 Avg Lat = 17290.24 us Count = 3447<\/address>\n
ran (large): nio=6895 nior=6895 niow=0 req w%=0 act w%=0<\/address>\n
ran (large): my 2 oth 5 iops 114 lat 17288.01 us bw = 114.85 MBps dur 60.04 s size 1024 K READ<\/address>\n
\u00a0<\/address>\n
Point 18 (small=5, large=2) of 18<\/address>\n
Valid small 1 Valid large 1<\/address>\n
Valid<\/address>\n
\u00a0<\/address>\n
TEST END<\/address>\n
\u00a0<\/address>\n
\u00a0<\/address>\n
Usage:<\/strong><\/address>\n
\u00a0<\/address>\n
[oracle]:> orion \u2013help<\/address>\n
\u00a0<\/address>\n
ORION: ORacle IO Numbers — Version 11.2.0.1.0<\/address>\n
\u00a0<\/address>\n
ORION runs IO performance tests that model Oracle RDBMS IO workloads.<\/address>\n
It measures the performance of small (2-32K) IOs and large (128K+) IOs<\/address>\n
at various load levels.<\/address>\n
\u00a0<\/address>\n
Each Orion data point is a test for a specific mix of small and large<\/address>\n
IO loads sustained for a duration. An Orion test consists of multiple<\/address>\n
data point tests. These data point tests can be represented as a<\/address>\n
two-dimensional matrix. Each column in the matrix represents data<\/address>\n
point tests with the same small IO load, but varying large IO loads.<\/address>\n
Each row represents data point tests with the same large IO load, but<\/address>\n
varying small IO loads. An Orion test can be for a single point, a<\/address>\n
single row, a single column, or the whole matrix.<\/address>\n
\u00a0<\/address>\n
The ‚run‘ parameter is the only mandatory parameter. Defaults<\/address>\n
are indicated for all other parameters. For additional information on<\/address>\n
the user interface, see the Orion User Guide.<\/address>\n
\u00a0<\/address>\n
<testname> is the prefix used for all input and output filenames. By<\/address>\n
default, it is ‚orion‘. It can be specified with the ‚testname‘<\/address>\n
parameter.<\/address>\n
\u00a0<\/address>\n
<testname>.lun should contain a carriage-return-separated list of LUNs.<\/address>\n
\u00a0<\/address>\n
The output files for a test run are prefixed by <testname>_<date> where<\/address>\n
date is „yyyymmdd_hhmm“.<\/address>\n
\u00a0<\/address>\n
The output files are:<\/address>\n
<testname>_<date>_summary.txt – Summary of the input parameters, along with<\/address>\n
the minimum small IO latency (in usecs), the maximum<\/address>\n
MBPS, and the maximum IOPS observed.<\/address>\n
<testname>_<date>_mbps.csv – Performance results of large IOs in MBPS.<\/address>\n
<testname>_<date>_iops.csv – Performance results of small IOs in IOPS.<\/address>\n
<testname>_<date>_lat.csv – Latency of small IOs (in usecs).<\/address>\n
<testname>_<date>_trace.txt – Extended, unprocessed output.<\/address>\n
\u00a0<\/address>\n
WARNING: IF YOU ARE PERFORMING WRITE TESTS, BE PREPARED TO LOSE ANY DATA STORED<\/address>\n
ON THE LUNS.<\/address>\n
\u00a0<\/address>\n
Mandatory parameters:<\/address>\n
run Type of workload to run (simple, normal, advanced, dss, oltp).<\/address>\n
simple – Tests random small (8K) IOs at various loads,<\/address>\n
then random large (1M) IOs at various loads.<\/address>\n
normal – Tests combinations of random small (8K) IOs and<\/address>\n
random large (1M) IOs.<\/address>\n
advanced – Tests the workload specified by the user<\/address>\n
using optional parameters.<\/address>\n
dss – Tests with random large (1M) IOs at increasing<\/address>\n
loads to determine the maximum throughput.<\/address>\n
oltp – Tests with random small (8K) IOs at increasing<\/address>\n
loads to determine the maximum IOPS.<\/address>\n
\u00a0<\/address>\n
Optional parameters:<\/address>\n
testname Name of the test run.<\/address>\n
\u00a0<\/address>\n
num_disks Number of disks (physical spindles). This number is<\/address>\n
used to gauge the range of loads that Orion should test<\/address>\n
at. Increasing this parameter results in Orion using<\/address>\n
heavier IO loads. Default is the number of LUNs in<\/address>\n
<testname>.lun.<\/address>\n
\u00a0<\/address>\n
size_small Size of small IOs in KB. Default is 8.<\/address>\n
\u00a0<\/address>\n
size_large Size of large IOs in KB. Default is 1024.<\/address>\n
\u00a0<\/address>\n
type Type of large IOs (rand, seq). Default is rand.<\/address>\n
rand – Randomly distributed large IOs.<\/address>\n
seq – Sequential streams of large IOs.<\/address>\n
\u00a0<\/address>\n
num_streamIO Number of concurrent IOs per stream. This parameter is only<\/address>\n
used if -type is seq. Default is 4.<\/address>\n
\u00a0<\/address>\n
simulate Orion tests on a virtual LUN formed by combining the<\/address>\n
specified LUNs in one of these ways. This parameter is<\/address>\n
typically only used if -type is seq. Default is concat.<\/address>\n
concat – A serial concatenation of the LUNs. Each<\/address>\n
sequential stream issues IOs to only one LUN.<\/address>\n
raid0 – A RAID-0 mapping across the LUNs. Each<\/address>\n
sequential stream issues IOs across all LUNs,<\/address>\n
using RAID-0 striping.<\/address>\n
\u00a0<\/address>\n
write Percentage of IOs that are writes (SEE WARNING ABOVE).<\/address>\n
Default is 0.<\/address>\n
\u00a0<\/address>\n
cache_size Size in MBs of the array’s cache.<\/address>\n
Unless this option is set to 0, Orion issues a number<\/address>\n
of unmeasured, random IOs before each large sequential<\/address>\n
data point. These IOs fill up the storage array’s cache<\/address>\n
(if any) with random data so that IOs from one<\/address>\n
data point do not result in cache hits for the next<\/address>\n
data point. Read tests are preceded with junk reads<\/address>\n
and write tests are preceded with junk writes. If<\/address>\n
specified, this ‚cache warming‘ is performed until<\/address>\n
cache_size MBs of IO have been read or written.<\/address>\n
Default behavior is to issue 2 minutes of unmeasured random<\/address>\n
IOs before each data point.<\/address>\n
\u00a0<\/address>\n
duration Duration of each data point in seconds. Default is 60.<\/address>\n
\u00a0<\/address>\n
num_small Number of outstanding small IOs. This parameter controls the<\/address>\n
small IO load. Only used if -matrix is point, col, or max.<\/address>\n
No default.<\/address>\n
\u00a0<\/address>\n
num_large This parameter controls the large IO load.<\/address>\n
For -type rand, number of outstanding large IOs.<\/address>\n
For -type seq, number of sequential IO streams. Only used<\/address>\n
if -matrix is point, row, or max. No default.<\/address>\n
\u00a0<\/address>\n
matrix An Orion test consists of multiple data point tests. These data<\/address>\n
point tests can be represented as a two-dimensional matrix.<\/address>\n
Each column in the matrix represents data point tests with<\/address>\n
the same small IO load, but varying large IO loads. Each<\/address>\n
row represents data point tests with the same large IO load,<\/address>\n
but varying small IO loads. An Orion test can be for a<\/address>\n
single point, a single row, a single column, or the whole<\/address>\n
matrix, depending on the matrix option setting below.<\/address>\n
Default is basic.<\/address>\n
basic – Test small IOs only, then large IOs only.<\/address>\n
detailed – Test entire matrix.<\/address>\n
point – Test with num_small small IOs, num_large large<\/address>\n
IOs.<\/address>\n
col – Test a varying large IO load with num_small<\/address>\n
small IOs.<\/address>\n
row – Test a varying small IO load with num_large<\/address>\n
large IOs.<\/address>\n
max – Test varying loads up to the num_small and<\/address>\n
num_large limits.<\/address>\n
\u00a0<\/address>\n
verbose Prints tracing information to standard output if set.<\/address>\n
Not set by default.<\/address>\n
\u00a0<\/address>\n
Examples:<\/address>\n
For a preliminary set of data<\/address>\n
-run simple<\/address>\n
For a basic set of data<\/address>\n
-run normal<\/address>\n
To evaluate storage for an OLTP database<\/address>\n
-run oltp<\/address>\n
To evaluate storage for a data warehouse<\/address>\n
-run dss<\/address>\n
To generate combinations of 32KB and 1MB reads to random locations<\/address>\n
-run advanced<\/address>\n
-size_small 32 -size_large 1024 -type rand<\/address>\n
-matrix detailed<\/address>\n
To generate multiple sequential 1MB write streams, simulating RAID0 striping<\/address>\n
-run advanced<\/address>\n
-simulate RAID0 -write 100 -type seq<\/address>\n
-matrix col -num_small 0<\/address>\n
\u00a0<\/address>\n","protected":false},"excerpt":{"rendered":"

Die Performance einer Datenbank wird entscheidend gepr\u00e4gt von dem I\/O Verhalten des Platten-Subsystems. Mit Oracle 11gR2 wird standardm\u00e4ssig das Werkzeug \u201eorion\u201c mit installiert. Beschrieben ist \u201eorion\u201c im Oracle Performance Tunig Guide Kapitel 8. \u201eorion\u201c erlaubt eine Vorhersage der I\/O Performance … Weiterlesen →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/153"}],"collection":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=153"}],"version-history":[{"count":20,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions"}],"predecessor-version":[{"id":319,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=\/wp\/v2\/posts\/153\/revisions\/319"}],"wp:attachment":[{"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jal-bs.de\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}