Re: Chronic Performance Problems

From: jhy <jhy_at_earthling.net>
Date: Thu, 23 Jul 1998 21:51:51 -0400
Message-ID: <6p8pbr$rhd@bgtnsc02.worldnet.att.net>

Are you using the default ORCL instance or did you create a new one? The default ORCL instance is tiny and won't handle much of a workload.

Eoin Murphy wrote:

> We've a new system Oracle 7.3 with a VB front end. If one user is using
> the system it's fine but when another logs on everything takes twice as
> long and with three users three times and so on. It doesn't appear to
> queue requests but merely slows all down.
> The VB front end logs all users into Oracle using one ID but testing
> with more than one ID didn't appear to yield any performance
> improvement.
> We're using NT Server and Oracle objects.
> Is there some setting we should be looking at?
>
> Any advice, greatly appreciated.
>
> -Eoin.
Received on Thu Jul 23 1998 - 20:51:51 CDT