why not use iometer and have it cycle through with a queue depth. After a
certain interval of time, it adds to the queue depth and reruns the test.
You'll be able to get the IOPS from it. Sooner or later you will come to a
point where the IOPS levels off and then starts degrading. If the backend is
a clariion, you can try with the caching turned on for the Lun or off. You
don't get that control on a DMX though.
I was at an EMC conference a while back and they discussed the tools they use and bonnie and had problems. They said iometer did a better job of measuring. Of course they had their own tool but it's not available for us mere mortals :)
----- Original Message ----- From: <oracle-l-bounce@xxxxxxxxxxxxx>
To: <BSpears@xxxxxxxxxxxxxxxxx>; <HELMUT.DAIMINGER@xxxxxx>; <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, November 18, 2005 11:25 AM
Subject: RE: How to generate a lot of load on an Oracle database?
We need to test the maximum I/O throughput of our SAN storage system and therefore need an Oracle database to generate so much load that there is an I/O bottleneck. Does anybody out there have open source tools or Oracle scripts for that?
This is 9.2 on HP-UX 11i and EMC Clariion.
...use Orion (http://www.oracle.com/technology/software/tech/orion/index.html) and make sure the files are larger than the array cache. I go over array head testing a bit in this paper http://www.polyserve.com/pdf/VMDB_Summary_WP.pdf