RE: How to generate a lot of load on an Oracle database?
- From: "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
- To: <HELMUT.DAIMINGER@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 21 Nov 2005 13:06:55 -0500
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@xxxxxxxxxxxxxx]
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@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:
