Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How should I do the load testing?

Re: How should I do the load testing?

From: <boogab00_at_yahoo.com>
Date: 23 Aug 2006 13:15:56 -0700
Message-ID: <1156364156.101340.236940@75g2000cwc.googlegroups.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US