Re: SwingBench as a Benchmarking or StressTesting tool

I have developed for my own use a small Java (1.5) + JDBC (I know ...) tool that can execute repeatedly SQL statements.

It has four nice features :

* It works with Oracle AND other products (just in case)
* It can generate random bind values
* It can create multiple threads, you can set a frequency of execution, etc.
* It's free, and OpenSource (GPL).

I intend to put it on the RoughSea site one of these days. Email me if you can't wait.

HTH Stephane Faroult

Hemant K Chitale wrote:

>
> 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
>>
>>
>> -----Original Message-----
>> From: oracle-l-bounce_at_freelists.org
>> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hemant K Chitale
>> Sent: Tuesday, September 13, 2005 11:46 AM
>> To: Oracle-L
>> Subject: SwingBench as a Benchmarking or StressTesting tool
>>
>>
>> Can anyone provide me feedback on having used SwingBench as a
>> Benchmarking or StressTesting tool ?
>>
>> http://www.oracle.com/technology/tech/linux/vmware/cookbook/stage6_swing
>> bench.html
>>
>> or
>>
>> http://www.dominicgiles.com/swingbench.php
>>
>> 1. How easy was it to setup {say the Order Entry test} 2. How long
>> does it take to setup {say, to simulate 50 concurrent sessions}
>>
>>
>>
>> Hemant K Chitale
>> http://web.singnet.com.sg/~hkchital
>>
>>
>> --
>> http://www.freelists.org/webpage/oracle-l
>
>
>
> Hemant K Chitale
> http://web.singnet.com.sg/~hkchital
>

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