Re: How to generate a lot of load on an Oracle database?

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

--
http://www.freelists.org/webpage/oracle-l





--
http://www.freelists.org/webpage/oracle-l


Other related posts: