Oracle ORION IO Test Tool usage Overview

. ORION Overview

1.1 ORION Description

ORION (Oracle I/O calibration Tool) is an independent tool for calibrating storage-system I/O performance for Oracle databases. Calibration results are useful for understanding the performance of the storage system, not only to identify problems affecting Oracle database performance, but also to measure the size of the new database installation. Since ORION is a stand-alone tool, users do not need to create and run Oracle databases.

The Orion download address is:

Http://www.oracle.com/technology/global/cn/software/tech/orion/index.html

To simulate Oracle databases as much as possible, ORION uses the same I/O software set as Oracle to generate a synthetic I/O load. ORION can be configured to generate a lot of I/O loads, including an I/O load that simulates OLTP and data warehouse loads.

ORION supports a variety of platforms. Support for more platforms will be added in the future. The user's Guide provides detailed usage documentation, including the Getting Started section and troubleshooting tips. Invoking the "-help" option in Orion is a straightforward way to get a summary of how to use Orion.

Note that Oracle does not provide support for Orion.

Advantage:

1, do not need to run the load runner and configure a large number of clinet

2, do not need to run the Oracle database, and prepare a large number of test data

3, the test results are more representative, such as random IO test, the software can let the storage hit rate close to 0, and more simulation of the actual disk of IOPS, and load runner difficult to do these, the final disk ioPS need to be converted.

4, can be customized according to the needs of a certain percentage of the write operation (the default does not write operations), but need to note that if there is data on the disk, you need to be careful that the data is overwritten.

Disadvantages

1. Up to now, it is completely automatic to specify the total elapsed time of the custom and the range of pressurization.

2, can not do some custom type of operation, such as table scan operation, load test, etc., but it could be combined with Oracle database to achieve this effect.

1.2 ORION Help

C:\Program Files (x86) \oracle\orion>orion-help

Orion:oracle IO Numbers--Version10.2.0.1.0

ORION runs IO performance tests that modeloracle RDBMS io workloads.

It measures the performance of Small (2-32k) iOS and Large (128k+) iOS at various load levels.  Each of the Orion data point are done in a specific mixof small and large IO loads sustained for a duration. Anywhere from a single data point to atwo-dimensional array of data points can is tested by setting the rightoptions.

An Orion test consists of data points atvarious small and large IO load levels. These points can be represented as a two-dimensional matrix:each columnin The matrix represents a fixed small IO load.  Each row represents a fixedlarge IO load.  The "a" and no largeio load with no small IO load. An Orion test can is a single point, a row, acolumn or the whole matrix.

Parameters ' run ', ' testname ', and ' num_disks ' are mandatory.  Defaults are indicated for all otherparameters. For additional information on the user interface, the Orion user Guide.

--The run oraion must contain run,testname,num_disks three parameters.

<testname>.lun should contain acarriage-return-separated list of LUNs the output files for a test run areprefixed by <testname>_.

The output files are:

<testname>_summary.txt-summary ofthe input parameters along with min. small latency, max large MBPS and/or ll IOPS.

<testname>_mbps.csv-performanceresults of large IOs in Mbps (throughput)

<testname>_iops.csv-performanceresults of small iOS in ioPS (io times per second)

<testname>_lat.csv-latency of Smallios (response time)

<testname>_tradeoff.csv-shows Largembps/small IOPS combinations that can is achieved at certain small

<testname>_trace.txt-extended,unprocessed output (tracking information, most detailed data)

The--orion execution ends with the output of 5 files, each of which will refer to the above description for different functions.

Warning:if you ARE performing WRITE Tests,be PREPARED to lose any DATA STORED on the LUNs.

Mandatory parameters (mandatory parameter description):

Run Type of workload to run (simple, normal, advanced)

simple-tests Random 8K small IOs at various loads,then random 1M Largeios at various loads.

normal-tests combinations of random8k small iOS and random 1M large iOS

Advanced-run theworkload specified by the user using optional parameters