Re: Chronic Performance Problems

On Thu, 23 Jul 1998, 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?

One of the simplest things to check is the DB_BLOCK_BUFFERS variable in init<SID>.ora, where <SID> is the SID of your instance. The default value for this is quite small and inadequate for anything but small databases. Also, look through the Oracle documentation in regards to application tuning - An key issue is that the order of the parts of a query can make a big difference to its perfomance.
Try to have the most selective clauses first.
>
> -Eoin.
>
>
>

• Richard 'Frog' Barrott --------------------------------|--------------------------------------------- u952297_at_student.canberra.edu.au | QUOTE OF THE WEEK: <insert email address here> | "...captial punishment is our society's | recognition of the sanctity of human life." Ph: Australia 041-2180878 | - Orrin Hatch (US Senator) --------------------------------/