Re: Tool to load test an Oracle Server

[Quoted] You need to be careful in doing this type of testing. You want to mimic what your application is doing. For example a lot of tools (I am not familiar with Orapub so I am not commenting on it) do not use bind variables [Quoted] (which you should be using) and thus drive the CPU usage up the wall. That [Quoted] is they may not accurately reflect what you are going to be doing. The [Quoted] problem with that is that you might spend money on CPU for example when you [Quoted] should be spending it on disks. The model should closely imitate reality. Jim
"James Lorenzen -XIOtech Corporation" <james_lorenzen_at_xiotech.com> wrote in [Quoted] [Quoted] message news:908f4g$91h$1_at_nnrp1.deja.com...
> Adam, I was looking for something to create a "real world" type load for
> disk performance testing. I work for a SAN vendor and I found something
> from Orapub written by Craig Shallahamer. I made some changes to it,
> but the basics are there and I was able to "push" a dual pentium (933's)
> at 60 to 70% with it (the disk was averaging 14 megabytes per second).
>
> The his site is www.orapub.com.
>
> HTH
> James
>
> In article <3A2771E7.B6C5797D_at_netall.co.uk>,
> Adam Woolhouse <adamw_at_netall.co.uk> wrote:
> > Does anyone know of a freeware, or any other tool to test an oracle
> > database?
> >
> > We need to to be able to set up an oracle database from scratch, stuff
> > it with tables and dummy data and then get the oracle database to
> > manipulate the data and then give us results.
> >
> > The database should be enough to tax the servers so that it will slow
> > them down demonstrably.
> >
> > We are testing two systems to see which one works the fastest. This
> > will be a two teir database with a database server and a fileserver
 back
> > end.
> >
> > Help please, direcclt to my email address and copied to this
> > newsgroup.
> >
> > Thanks in advance.
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Dec 02 2000 - 07:24:01 CET