ORION – Oracle I/O Numbers Calibration Tool
Thanks to Franck Pachot post on dba-village.com, I re-discovered the Oracle tool for benchmarking I/O subsystem, called ORION (the link to this tool was posted by Tony van Esch on October 2005 on dba-village as well — I did bookmarked that link back then, but flushed from my memory cache soon after).
Orion can be downloaded from OTN:
It’s available for AIX, Solaris, Linux and Windows. From the same URL you can also download ORION Users Guide – it’s short and to the point.
I tested ORION on Windows XP with 8GB raw partition; basically I followed Users guide.
1) Installed orion with msi package 2) I created raw partition and assigned letter X: to it 3) created mytest.lun file within directory where orion was installed to. File mytest.lun has single line, since I tested with single "disk": \\.\X: 4) run simple I/O test D:\ORACLE\ORION>orion -run simple -testname mytest -num_disks 1 ORION: ORacle IO Numbers -- Version 10.2.0.1.0 Test will take approximately 9 minutes Larger caches may take longer 5) orion writes results in txt/csv files. Follow instructions in Users Guide if you wish to graphically represent the data in your spreadsheet of choice.
The tool has numerous options, so make sure you read ORION Users Guide!
Original question that triggered Franck reply was: is there equivalent tool for Oracle as it’s for MS SQL Server, SQLIO.EXE (an I/O meter for SQL Server). So, if you’re responsible (doomed) for SQL Servers maintenance as well and want to adequately measure I/O throughput of underlying storage, then SQLIO.EXE is the tool for you.