Re: Tool to load test an Oracle Server

[Quoted] But then of course a lot of applications especially if they have been written with tools supporting multiple databases, don't use bind variables too.

So far, in my firm I didn't meet any developer using bind variables when using jdbc and/or odbc.

Regards,

Sybrand Bakker, Oracle DBA

"Barbara Kennedy" <barbken_at_teleport.com> wrote in message news:8C0W5.522$Y4.156185_at_nntp1.onemain.com...
> 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
> (which you should be using) and thus drive the CPU usage up the wall.
 That
> is they may not accurately reflect what you are going to be doing. The
> problem with that is that you might spend money on CPU for example when
 you
> should be spending it on disks. The model should closely imitate reality.
> Jim
> "James Lorenzen -XIOtech Corporation" <james_lorenzen_at_xiotech.com> wrote
 in
> 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 Sun Dec 03 2000 - 09:34:25 CET