Re: How should I do the load testing?

emdproduction_at_hotmail.com wrote:
> Group,
>
> We are using a new database link to a remote database. Most of the job
> will be select data from this remote database.
>
> I need to run some load testing, simulating about 80 people to select
> against this remote database at the same time, what is the best way to
> do it? Open up 80 sqlplus sessions to run an dead loop pl/sql?
>
> Any better way of doing it? Or is there any software/script to do
> this?
>
> Thanks for your help

The best way to do it is to not do it. 80 concurrent queries against a remote database is not going to perform well. Maybe response time is not an issue. Is there REALLY a valid reason for not placing this business function in the remote database? Received on Wed Aug 23 2006 - 15:15:56 CDT