Re: Chronic Performance Problems

From: <asprusch_at_my-dejanews.com>
Date: Fri, 24 Jul 1998 06:29:21 GMT
Message-ID: <6p99k1$nil$1@nnrp1.dejanews.com>

That's seems like a locking problem. Monitor the database for lock waits (for example use utllockt.sql in /rdbms/admin directory. Attention: catblock.sql in the same directory must executed once before the first usage of utllockt.sql).

Hope this will help,
Andreas Prusch

In article <35B77861.9689CAFB_at_digital.com>, Eoin Murphy <eoin.murphy_at_digital.com> 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.
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 24 1998 - 01:29:21 CDT