. ORION 概述
1.1 ORION 说明
ORION (Oracle I/O Calibration Tool) 是校准用于 Oracle 数据库的存储系统 I/O 性能的独立工具。校准结果对于了解存储系统的性能有很大帮助,不仅可以找出影响 Oracle 数据库性能的问题,还能测量新数据库安装的大小。由于 ORION 是一个独立工具,用户不需要创建和运行 Oracle 数据库。
Orion的下载地址为:
http://www.oracle.com/technology/global/cn/software/tech/orion/index.html
为了尽可能地模拟 Oracle 数据库,ORION 使用和 Oracle 相同的 I/O 软件集生成一个合成的 I/O 负载。可以将 ORION 配置为生成很多 I/O 负载,包括一个模拟 OLTP 和数据仓库负载的 I/O 负载。
ORION 支持多种平台。将来还会增加对更多平台的支持。用户指南提供详细的使用文档,包括“入门”部分和疑难解答提示。在 ORION 中调用“-help”选项可以直接获取关于如何使用 ORION 的摘要。
注意,Oracle 不对 ORION提供支持。
优势:
1、不需要运行load runner以及配置大量的clinet
2、不需要运行oracle数据库,以及准备大量的测试数据
3、测试结果更具有代表性,如随机IO测试中,该软件可以让存储的命中率接近为0,而更仿真出了磁盘的真实的IOPS,而load runner很难做到这些,最终的磁盘IOPS需要换算得到。
4、可以根据需要定制一定比例的写操作(默认没有写操作),但是需要注意,如果磁盘上有数据,需要小心数据被覆盖掉。
缺点
1、到现在为止,无法指定自定义的总体的运行时间以及加压的幅度,这里完全是自动的.
2、无法进行一些自定义的操作类型,如表的扫描操作,装载测试等等,不过可以与oracle数据库结合起来达到这个效果.
1.2 ORION 帮助
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 Orion data point is done at 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 be 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 first row is with no largeIO load and the first column is with no small IO load. An Orion test can be 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, see the Orion User Guide.
--运行ORAION必须包含run,testname,num_disks 三个参数。
<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 max.small IOPS.
<testname>_mbps.csv - Performanceresults of large IOs in MBPS(吞吐量)
<testname>_iops.csv - Performanceresults of small IOs in IOPS(每秒IO次数)
<testname>_lat.csv - Latency of smallIOs(响应时间)
<testname>_tradeoff.csv - Shows largeMBPS / small IOPS combinations that can be achieved at certain small latencies
<testname>_trace.txt - Extended,unprocessed output(跟踪信息,最详细的数据)
--ORION 执行结束会输出5个文件,每个文件的不同作用参考上面的说明。
WARNING: IF YOU ARE PERFORMING WRITE TESTS,BE PREPARED TO LOSE ANY DATA STORED ON THE LUNS.
Mandatory parameters(强制的参数说明):
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