{"id":2193,"date":"2011-03-24T10:12:00","date_gmt":"2011-03-24T09:12:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/"},"modified":"2011-03-24T10:12:00","modified_gmt":"2011-03-24T09:12:00","slug":"simulating-and-testing-io-performances-with-orion","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/","title":{"rendered":"Simulating and testing I\/O performances with ORION"},"content":{"rendered":"<p>Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}\/bin). ORION &#8211; ORacle Input Output Numbers &#8211; is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with. ORION basically supports four kinds of database activities based on either small or large I\/O. ORION can, as any respectable I\/O simulation tool, generate an adapted workload using a given percentage of reads and write operations.<\/p>\n<h3>OLTP activity<\/h3>\n<p>ORION can simulate OLTP systems typically generating small random read and write activities. The I\/O sizes are equivalent to the database block size (usually 8KB) and the application analyzes the following database I\/O KPIs:<\/p>\n<ul>\n<li>IOPS (I\/O Per seconds)<\/li>\n<li>I\/O latency average (I\/O turn-around time) per request<\/li>\n<\/ul>\n<p>The first part of the &#8220;simple&#8221; run (option -run simple) simulates this kind of workload (only with read). ORION also provides an OLTP-like (option -run oltp) scheme in which you can specify the percentage of writes.<\/p>\n<h3>Large sequential read activity<\/h3>\n<p>ORION can also simulate large sequential I\/Os which can be caused by database exports (through data pump), RMAN backup, or of course a data warehouse environment. In this case, large I\/Os will be simulated (1 MB per default). These types of applications or procedures are processing large amount of data and the important KPI is the throughput in MBps (MB per seconds). In this case, ORION can simulate large I\/O read or write streams.<\/p>\n<p>This kind of workload requires the option &#8220;-type seq&#8221; to be set in order to simulate large sequential I\/Os. The &#8220;mixed&#8221; workload through a workload &#8220;matrix&#8221; might also be used, see below.<\/p>\n<h3>Large random read activity<\/h3>\n<p>Large random I\/O is another kind of workload ORION can simulate. The tool therefore simulates large I\/Os stripped over several disk, allowing to simulate parallel activities. In this case, multiple large I\/O streams are started against the available disks.<\/p>\n<p>The &#8220;dss&#8221; run (option -run dss) simulates this type of activity.<\/p>\n<h3>Mixed Workload<\/h3>\n<p>Finally, the mixed workload allows to simulate together small random I\/Os and large sequential or random I\/Os. Of course, this workload type is useful for OLTP systems confronted with performance issues caused by online backups for instance. A percentage of writes can also be simulated during these tests.<\/p>\n<p>The &#8220;normal&#8221; run (option -run normal) simulates mixed activity of the sort, but of course the &#8220;matrix&#8221; workload is perfectly adapted to this simulation.<\/p>\n<p>ORION has one major drawback: It cannot perform a filesystem performance analysis. It was only designed to be started against devices. We tested it on raw devices, since they are not buffered as block devices.<br \/>\nORION can be used to test performances of disks, luns, SAN, DAS, or even certain type of NAS (we have not tested this so far).<\/p>\n<p>In order to prepare the test, first of all we have to purge the raw device(s) on which we will generate the load:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># dd if=\/dev\/zero of=\/dev\/raw\/raw1 bs=1k count=1000\n1000+0 records in\n1000+0 records out\n1024000 bytes (1.0 MB) copied, 3.52424 seconds, 291 kB\/s<\/pre>\n<p>A file containing the devices on which the load will be generated on must be created (testname.lun):<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># cat simpletest.lun\n\/dev\/raw\/raw1<\/pre>\n<p>ORION offers a very interesting feature. Since most of the SAN have caches, there is a risk of being impacted by &#8220;cache hits&#8221; during the I\/O load tests. For this purpose ORION will generate random I\/O which cannot be re-used by the test in order to full-fill the SAN cache and avoid the &#8220;I\/O cache hit&#8221; effect. ORION even offers the possibility to set the size of the SAN cache in order to be quite precise. If this parameter is not set, ORION fulfills per default during 2 minutes the cache with useless I\/O.<a href=\"#_msocom_1\" name=\"_msoanchor_1\"><\/a><\/p>\n<p>In order to run a so called &#8220;simple test&#8221;, the &#8220;-run simple&#8221; option can be used. Take care that this test scheme will not mix up several types of workload. Small random I\/O will be performed separated from large random and sequential I\/Os. Moreover, only reads are simulated in this test scheme. Note that ORION refuses to start without a fully qualified path:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># orion -run simple -testname simpletest\n\u00a0\nORION: ORacle IO Numbers -- Version 11.2.0.2.0\nsimpletest_20110201_1550\nCalibration will take approximately 9 minutes.\nUsing a large value for -cache_size may take longer.\nORA-56727: orion must be invoked using its full, absolute path\norion_main: orion_spawn sml failed\nTest aborted due to errors.<\/pre>\n<p>Once started as expected, the following output is generated:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># $ORACLE_HOME\/bin\/orion -run simple -testname simpletest\n\u00a0\nORION: ORacle IO Numbers -- Version 11.2.0.2.0\nsimpletest_20110201_1551\nCalibration will take approximately 9 minutes.\nUsing a large value for -cache_size may take longer.\nMaximum Large MBPS=101.82 @ Small=0 and Large=2\nMaximum Small IOPS=635 @ Small=5 and Large=0\nSmall Read Latency: avg=7867 us, min=1858 us, max=210500 us, std dev=4914 us @ Small=5 and Large=0\nMinimum Small Latency=7867 usecs @ Small=5 and Large=0\nSmall Read Latency: avg=7867 us, min=1858 us, max=210500 us, std dev=4914 us @ Small=5 and Large=0\nSmall Read \/ Write Latency Histogram @ Small=5 and Large=0\nLatency:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # of IOs (read)\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0# of IOs (write)\n0 - 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n2 - 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n4 - 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n8 - 16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n16 - 32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n32 - 64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n64 - 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n128 - 256\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n256 - 512\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n512 - 1024\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n1024 - 2048\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 470\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n2048 - 4096\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4863\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n4096 - 8192\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 19006\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n8192 - 16384\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 12410\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n16384 - 32768\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1207\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\n32768 - 65536\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 138\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n65536 - 131072\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 23\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n131072 - 262144\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n262144 - 524288\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\n524288 - 1048576\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n1048576 - 2097152\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n2097152 - 4194304\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n4194304 - 8388608\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\n8388608 - 16777216\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n16777216 - 33554432\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n33554432 - 67108864\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n67108864 - 134217728\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n134217728 - 268435456\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/pre>\n<p align=\"center\">&#8211; Orion output 1 &#8211;<\/p>\n<p>The output represented above shows:<\/p>\n<ul>\n<li>Maximum MBPS (MB per seconds): 101<\/li>\n<li>Maximum IOPS (I\/O per seconds): 635<\/li>\n<li>I\/O latencies information<\/li>\n<\/ul>\n<p>The following files are produced:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\">-rw-r--r-- 1 oracle dba\u00a0\u00a0 174 Feb\u00a0 1 12:50 simpletest_20110201_1550_trace.txt\n-rw-r--r-- 1 oracle dba\u00a0\u00a0 342 Feb\u00a0 1 12:50 simpletest_20110201_1550_summary.txt\n-rw-r--r-- 1 oracle dba\u00a0\u00a0\u00a0\u00a0 0 Feb\u00a0 1 12:50 simpletest_20110201_1550_mbps.csv\n-rw-r--r-- 1 oracle dba\u00a0\u00a0\u00a0\u00a0 0 Feb\u00a0 1 12:50 simpletest_20110201_1550_lat.csv\n-rw-r--r-- 1 oracle dba\u00a0\u00a0\u00a0\u00a0 0 Feb\u00a0 1 12:50 simpletest_20110201_1550_iops.csv\n-rw-r--r-- 1 oracle dba\u00a0\u00a0 982 Feb\u00a0 1 12:50 simpletest_20110201_1550_hist.txt\n-rw-r--r-- 1 oracle dba\u00a0 3227 Feb\u00a0 1 12:58 simpletest_20110201_1551_trace.txt\n-rw-r--r-- 1 oracle dba\u00a0 1773 Feb\u00a0 1 12:58 simpletest_20110201_1551_summary.txt\n-rw-r--r-- 1 oracle dba\u00a0\u00a0 498 Feb\u00a0 1 12:58 simpletest_20110201_1551_mbps.csv\n-rw-r--r-- 1 oracle dba\u00a0\u00a0 549 Feb\u00a0 1 12:58 simpletest_20110201_1551_lat.csv\n-rw-r--r-- 1 oracle dba\u00a0\u00a0 526 Feb\u00a0 1 12:58 simpletest_20110201_1551_iops.csv\n-rw-r--r-- 1 oracle dba\u00a0 7033 Feb\u00a0 1 12:58 simpletest_20110201_1551_hist.txt<\/pre>\n<p>These files contain useful information about I\/O performances and have the following structure:<\/p>\n<ul>\n<li>Lines represent large I\/O load levels (number of outstanding large I\/Os)<\/li>\n<li>Columns represent small I\/O load levels (number of outstanding small I\/Os)<\/li>\n<\/ul>\n<p>Since there is no small\/large I\/O mix up in the &#8220;simple&#8221; test, the tables stored in the generated files will have only one dimension (either one column or one row).<\/p>\n<p>The file containing the throughput performances measured in MBPS (MB per second) has the following layout:<\/p>\n<p><span style=\"font-family: courier new,courier;\"><i># cat simpletest_20110201_1551_mbps.csv<\/i><\/span><\/p>\n<p>This comma-separated-value file contains the rates sustained by large I\/Os in MBps. Each value corresponds to a data point test that used a fixed number of outstanding small and large I\/Os. The number of outstanding small I\/Os for a value is specified by its column header in the first row. The number of outstanding large I\/Os for a value is specified by its row header in the first column.<\/p>\n<p><span style=\"font-family: courier new,courier;\">Large\/Small,\u00a0\u00a0\u00a0\u00a0\u00a0 0,\u00a0\u00a0\u00a0\u00a0\u00a0 1,\u00a0\u00a0\u00a0\u00a0\u00a0 2,\u00a0\u00a0\u00a0\u00a0\u00a0 3,\u00a0\u00a0\u00a0\u00a0\u00a0 4,\u00a0\u00a0\u00a0\u00a0\u00a0 5<\/span><\/p>\n<p><span style=\"font-family: courier new,courier;\">1,\u00a0 56.41<br \/>\n2, 101.82<\/span><\/p>\n<p>In our example, the highest throughput is 101 MB\/s. This value is rather weak for a SAN. The faster SANs reach up to 200 or 300 MB\/s.<br \/>\nThe I\/O latency can be found in the following .csv file (simpletest_20110201_1551_lat.csv):<\/p>\n<p><span style=\"font-family: courier new,courier;\"><i># cat simpletest_20110201_1551_lat.csv<\/i><\/span><\/p>\n<p>&nbsp;<\/p>\n<p>This comma-separated-value file contains the average latency sustained by small I\/Os in microseconds. Each value corresponds to a data point test that used a fixed number of outstanding small and large I\/Os. The number of outstanding small I\/Os for a value is specified by its column header in the first row. The number of outstanding large I\/Os for a value is specified by its row header in the first column.<\/p>\n<p><span style=\"font-family: courier new,courier;\">Large\/Small,\u00a0\u00a0\u00a0\u00a0\u00a0 1,\u00a0\u00a0\u00a0\u00a0\u00a0 2,\u00a0\u00a0\u00a0\u00a0\u00a0 3,\u00a0\u00a0\u00a0\u00a0\u00a0 4,\u00a0\u00a0\u00a0 \u00a0\u00a05<br \/>\n0, 9478.83, 8590.16, 8097.65, 8089.16, 7866.98<br \/>\n1<br \/>\n2<\/span><\/p>\n<p>The measured latency is located between 7.8 to 9.4 ms. According to several forums, the accepted I\/O latency should be below 10ms. The average latency is indeed below 10ms, however 12410 (about one third) small I\/Os had a latency between 8 and 16ms (see above &#8211; Orion output 1 -).<\/p>\n<p>To simulate mixed up I\/O workload (small random, large random, and large sequential), you have to use the following command and perform a &#8220;normal&#8221; test:<\/p>\n<p><span style=\"font-family: courier new,courier;\"><i># $ORACLE_HOME\/bin\/orion -run normal -testname normaltest<\/i><\/span><\/p>\n<p>This command might fail after a while with the following output:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># $ORACLE_HOME\/bin\/orion -run normal -testname normaltest\nORION: ORacle IO Numbers -- Version 11.2.0.2.0\nnormaltest_20110201_1654\nCalibration will take approximately 19 minutes.\nUsing a large value for -cache_size may take longer.\nError completing \nIO(storax_aiowait)\nORA-27061: waiting for async I\/Os failed\nLinux-x86_64 Error: 14: \nBad addressAdditional information: -1\nAdditional information: 1048576\nTest aborted due to errors.<\/pre>\n<p>This issue is documented in the bug 9104898: &#8220;ORION FAILS WITH ORA-27061: WAITING FOR ASYNC I\/OS FAILED&#8221;. According to the bug description, ORION has difficulties with Large I\/Os on Red Hat Enterprise Linux Sever 5. The bug is currently under investigation at Oracle development.<\/p>\n<p>It is also possible to define exactly how many outstanding small and large I\/O you want ORION to simulate in parallel. For this purpose the &#8220;matrix&#8221; test should be used. In this case you specify the maximum number of outstanding small (-num_small) and large (-num_large) I\/Os. You can even specify the size for the large I\/O (depending on your infrastructure and future database settings):<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># $ORACLE_HOME\/bin\/orion -run advanced -testname advancedtest -matrix max -num_small 4 -num_large 4 -size_large 512\n\u00a0\nORION: ORacle IO Numbers -- Version 11.2.0.2.0\nadvancedtest_20110201_1740\nCalibration will take approximately 26 minutes.\nUsing a large value for -cache_size may take longer.<\/pre>\n<p>To simulate OLTP activities with about 20% of writes, the following parameters might be used:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># $ORACLE_HOME\/bin\/orion -run oltp -testname oltp_write -write 20\n\u00a0\nORION: ORacle IO Numbers -- Version 11.2.0.2.0\noltp_write_20110202_1140\nCalibration will take approximately 22 minutes.\nUsing a large value for -cache_size may take longer.\nMaximum Small IOPS=2820 @ Small=19 and Large=0\nSmall Read Latency: avg=8333 us, min=118 us, max=540359 us, std dev=9541 us @ Small=19 and Large=0\nSmall Write Latency: avg=315 us, min=217 us, max=11142 us, std dev=331 us @ Small=19 and Large=0\nMinimum Small Latency=5409 usecs @ Small=4 and Large=0\nSmall Read Latency: avg=6685 us, min=243 us, max=202301 us, std dev=5715 us @ Small=4 and Large=0\nSmall Write Latency: avg=300 us, min=217 us, max=6300 us, std dev=296 us @ Small=4 and Large=0\nSmall Read \/ Write Latency Histogram @ Small=19 and Large=0\nLatency:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # of IOs (read)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 # of IOs (write)\n0 - 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n2 - 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n4 - 8\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n8 - 16\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n16 - 32\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n32 - 64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n64 - 128\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n128 - 256\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6457\n256 - 512\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 339\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1894\n512 - 1024\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 115\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 369\n1024 - 2048\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2830\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 92\n2048 - 4096\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7105\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 44\n4096 - 8192\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16469\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 11\n8192 - 16384\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 7301\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n16384 - 32768\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1106\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n32768 - 65536\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 190\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n65536 - 131072\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 30\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n131072 - 262144\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n262144 - 524288\u00a0\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\n524288 - 1048576\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n1048576 - 2097152\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n2097152 - 4194304\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n4194304 - 8388608\u00a0\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\n8388608 - 16777216\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n16777216 - 33554432\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n33554432 - 67108864\u00a0\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\n67108864 - 134217728\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0 \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a00\n134217728 - 268435456\u00a0\u00a0 us:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0<\/pre>\n<p>You will find the technical specifications concerning the hardware and operating system below:<\/p>\n<pre class=\"brush: actionscript3; gutter: true; first-line: 1\"># uname -a\nLinux serveroracle01 2.6.18-194.26.1.el5 #1 SMP x86_64 GNU\/Linux\n# cat \/etc\/redhat-release\nRed Hat Enterprise Linux Server release 5.5 (Tikanga)\nEVA: HSV210 (6220). Raid level of the virtual disk is Raid 5<\/pre>\n<h3>As a Summary<\/h3>\n<p>Considering all advantages and drawbacks, ORION is quite an interesting tool. However, as mentioned by several experts, this tool is mainly useful in case you are at the beginning of a project and have full access to the disk\/LUN configuration. It is definitively not a good idea to overwrite some LUNs on the production environment. ORION also allows realizing test schemes that are perfectly fitted to the database behavior and offer a robust framework to compare storage vendors and storage infrastructures.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Since Oracle 11.2, Oracle provides ORION in the RDBMS binaries (in ${ORACLE_HOME}\/bin). ORION is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.<\/p>\n<p>\u00a0<\/p>\n<p>ORION basically supports four kinds of database activities based on either small or large I\/O. ORION can, as any respectable I\/O simulation tool, generate an adapted workload using a given percentage of reads and write operations.<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197],"tags":[14,67,244],"type_dbi":[],"class_list":["post-2193","post","type-post","status-publish","format-standard","hentry","category-application-integration-middleware","tag-i-o","tag-performance","tag-workload"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Simulating and testing I\/O performances with ORION - dbi Blog<\/title>\n<meta name=\"description\" content=\"ORION - ORacle Input Output Numbers - is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Simulating and testing I\/O performances with ORION\" \/>\n<meta property=\"og:description\" content=\"ORION - ORacle Input Output Numbers - is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2011-03-24T09:12:00+00:00\" \/>\n<meta name=\"author\" content=\"Gr\u00e9gory Steulet\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Gr\u00e9gory Steulet\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\"},\"author\":{\"name\":\"Gr\u00e9gory Steulet\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"headline\":\"Simulating and testing I\/O performances with ORION\",\"datePublished\":\"2011-03-24T09:12:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\"},\"wordCount\":1330,\"commentCount\":0,\"keywords\":[\"I\/O\",\"Performance\",\"Workload\"],\"articleSection\":[\"Application integration &amp; Middleware\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\",\"name\":\"Simulating and testing I\/O performances with ORION - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2011-03-24T09:12:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\"},\"description\":\"ORION - ORacle Input Output Numbers - is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Simulating and testing I\/O performances with ORION\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098\",\"name\":\"Gr\u00e9gory Steulet\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g\",\"caption\":\"Gr\u00e9gory Steulet\"},\"description\":\"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \\\"Oracle Certified Professional 10g\\\", \\\"MySQL Cluster 5.1 Certified\\\", and \\\"Avaloq Certified Professional 2.6\\\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Simulating and testing I\/O performances with ORION - dbi Blog","description":"ORION - ORacle Input Output Numbers - is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/","og_locale":"en_US","og_type":"article","og_title":"Simulating and testing I\/O performances with ORION","og_description":"ORION - ORacle Input Output Numbers - is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.","og_url":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/","og_site_name":"dbi Blog","article_published_time":"2011-03-24T09:12:00+00:00","author":"Gr\u00e9gory Steulet","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Gr\u00e9gory Steulet","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/"},"author":{"name":"Gr\u00e9gory Steulet","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"headline":"Simulating and testing I\/O performances with ORION","datePublished":"2011-03-24T09:12:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/"},"wordCount":1330,"commentCount":0,"keywords":["I\/O","Performance","Workload"],"articleSection":["Application integration &amp; Middleware"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/","url":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/","name":"Simulating and testing I\/O performances with ORION - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2011-03-24T09:12:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098"},"description":"ORION - ORacle Input Output Numbers - is an I\/O calibration tool allowing to simulating and testing I\/O performances an Oracle database would be confronted with.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/simulating-and-testing-io-performances-with-orion\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Simulating and testing I\/O performances with ORION"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/7609faada8e4d63e04a28ae29e227098","name":"Gr\u00e9gory Steulet","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e1531483285469fe17ea7a769ce5d8a8a01847185e4245d9c4d22c575c7c6d3e?s=96&d=mm&r=g","caption":"Gr\u00e9gory Steulet"},"description":"Gr\u00e9gory Steulet has more than ten years of experience in database and infrastructure management, engineering, and optimization. He is specialized in Oracle technologies and high availability solutions (Oracle DataGuard, Data Replication Block Device). His expertise also includes Avaloq banking applications, as well as the open source field (MySQL, Unix\/Linux, etc.). Gr\u00e9gory Steulet is \"Oracle Certified Professional 10g\", \"MySQL Cluster 5.1 Certified\", and \"Avaloq Certified Professional 2.6\". Prior to joining dbi services, Gr\u00e9gory Steulet was Senior Consultant at Trivadis in Lausanne. He also worked as IT Administrator at Box Telecom in Miami Beach, Florida (USA). Gr\u00e9gory Steulet has an Executive MBA from the International Institute of Management in Technology, Fribourg (CH). He also holds a Bachelor's Degree in Business Administration and Computer Science from the University of Applied Sciences Western Switzerland. His branch-related experience covers Telecommunications, Financial Services \/ Banking, Logistics, Pharma etc.","url":"https:\/\/www.dbi-services.com\/blog\/author\/gregory-steulet\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=2193"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/2193\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=2193"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=2193"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=2193"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=2193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}