Re: Tool to load test an Oracle Server

Yes, I have run across that also. It is too bad. I have worked for places were we spent a lot of time getting it right (using bind variables, eliminating reparses, not getting the same data over and over again, tuning access paths, etc.) and found that it makes a big difference in both the responsiveness and scalability of the application. Sure in a development environment with 100 rows and two developers working against a server it looks fast enough.
Jim

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:90dp76$pb4m$2_at_ID-62141.news.dfncis.de...
> 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 - 17:24:41 CET