IO stress test using Orion

I ran into some long running deployments on Production database affecting end users. Same deployment on QA with production data ran in 12 hours but on production it ran for 4 days but didn't finished.

Production database was sitting on local disks where as QA was sitting on SAN. I ran some IO test using Oracle Orion and plotted them on graph.

I found tool really useful for DBA's and same can be used for comparing different storage options like ASM Vs Veritas FS etc.

- At load level of 2 outstanding large reads and 4 small reads we get a throughput of 185.28 MBPS on QA and 5.68 MBPS on PROD.

- At load level of 2 outstanding large reads and 4 small reads we get a throughput of 72993 IOPS on QA and 336 IOPS on PROD.

- At load level of 2 outstanding large reads and 4 small reads we get a throughput of 0.05 ms on QA and 11.9 ms on PROD.