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

  • From: "Spears, Brian" <BSpears@xxxxxxxxxxxxxxxxx>
  • To: <HELMUT.DAIMINGER@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 18 Nov 2005 12:13:51 -0500

I made script  which showed me meg per second per mount point... and I just
thrash the SAN and check the numbers. 
 
 I noticed over the years the meg per second on these SAN have increased
significantly.  I am told that most of the io just just written to memory
(cache) so that the speed of the underlying disk is not an issue.
 
Let me know if you would want that.
 
Brian

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Daiminger, Helmut
Sent: Friday, November 18, 2005 9:57 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: How to generate a lot of load on an Oracle database?



Hi! 

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. 

Thanks, 
Helmut 


Other related posts: