Content
Code (0 )
Comments (2)
Oracle Orion is a tool to help predict performance of I/O loads on Oracle databases. Orion is specifically designed for simulating and predicting I/O bottlenecks against Oracle databases. Oracle Orion is available for free download at this link.
Please note that Oracle Orion is not supported by Oracle:
The unsupported Oracle Orion disk I/O load utility only seems to work for raw devices on Linux and only runs on Windows and Linux, and this severely limits its usefulness as the majority of clients seem to be using OCFS or a CFS such as Veritas on Linux.
We tested it against the RAID0 set on our server, and against two regular file system disks, both gave back “Non test error occurred – Orion exiting” after the initial startup messages stating how long the test would take.
You can only do Orion read tests with disks you don’t want to write over as the write test will write over all data on the volumes you want to test according to the documentation. This appears to be a very dangerous tool for example if you specified the write test at a client site you could ruin their installation.
Also, clients probably won’t have RAWs just laying around to test against.
The Orion utility is more for setting up new systems, but only if they get it to use regular file systems instead of RAW only.
Sample test output:
SATA RAID DISK 0+1
-run advanced -type seq -testname simple -write 0 -num_disks 1 -simulate concat -verbose
This maps to this test:
Test: simple
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Sequential Streams
Number of Concurrent IOs Per Stream: 4
Force streams to separate disks: No
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:, 0
Large Columns:, 0, 1, 2
Total Data Points: 8
Name: /dev/sda5 Size: 174236073984
1 FILEs found.
Maximum Large MBPS=194.66 @ Small=0 and Large=1
Maximum Small IOPS=305 @ Small=5 and Large=0
Minimum Small Latency=12.80 @ Small=1 and Large=0
SCSI HARD DRIVE ST336754LC
-run advanced -type seq -testname simple -write 0 -num_disks 1 -simulate concat -verbose
This maps to this test:
Test: simple
Small IO size: 8 KB
Large IO size: 1024 KB
IO Types: Small Random IOs, Large Sequential Streams
Number of Concurrent IOs Per Stream: 4
Force streams to separate disks: No
Simulated Array Type: CONCAT
Write: 0%
Cache Size: Not Entered
Duration for each Data Point: 60 seconds
Small Columns:, 0
Large Columns:, 0, 1, 2
Total Data Points: 8
Name: /dev/sda1 Size: 106896384
1 FILEs found.
Maximum Large MBPS=78.04 @ Small=0 and Large=2
Maximum Small IOPS=546 @ Small=5 and Large=0
Minimum Small Latency=6.14 @ Small=2 and Large=0
| Comments |
|