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

Just reading these now...no mention of SwingBench? I have seen it at a client but not used it myself...looks very good. Seems to be rather unknown? Try google. Old post below.
hth  

Chris Marquez
Oracle DBA  

-----Original Message-----
From: Hemant K Chitale [mailto:hkchital_at_singnet.com.sg] Sent: Monday, September 19, 2005 10:19 AM To: Marquez, Chris; Oracle-L
Subject: RE: SwingBench as a Benchmarking or StressTesting tool

I was able to use SwingBench {the Order Entry PLSQL "benchmark"} as a Stress Testing tool to compare a Sun Solaris server with a Fujitsu Solaris server {the database being on a NetApp filer, so I just alternate between the two servers, using the same database files and parameters}.  

It is quite "tweakable" and I guess I will be using it more frequently.  

{My report to Management was combination of the TPM and ResponseTime figures from SwingBench and Wait-Times from StatsPack}.  

Hemant

At 10:24 PM Thursday, Marquez, Chris wrote:
>Hemant,
>
>I have not personally used it, but I know DBA who have.
>I think they have a free version and they seem to like and they are
>very technical people.
>
>I believe it has command line and java GUI.
>
>When they told me I was surprised I never heard it talked about
>before...putting load on the Oracle (and server) is often needed.
>Guess most people for (DBA) testing use the big boy tools form Mercury,

>Rational, Quest?
>
>
>hth
>
>Chris Marquez
>Oracle DBA

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Daiminger, Helmut Sent: Friday, November 18, 2005 9:57 AM
To: oracle-l_at_freelists.org
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

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