Re: Poor SQL*Plus Performance with 7.3.4 running on NT

Most times, I have found that improperly sized and numbers redo logs to be the single biggest performance black hole. For example, my NT PC has 10 redo logs of each 10 megs.

The second biggest problem is often improperly sized and number of rollback segments. For example, my PC has 20 rollback segments each with an initial and next extent of 5 megs (and an optimum of 40 megs).

Changing just these 2 items quadrupled the performance on my NT box ...

"David Mortimer" <david.mortimer_at_virgin.net> wrote in message news:85vjm8$3b3$1_at_nclient13-gui.server.virgin.net...
> We have a twin Pentium III cpu board with 512 MB of memory running NT 4.00
> SP5. One of the things we do with it is run UPDATE and INSERT scripts,
> these rarely absorbe more than 10% of CPU time and take a long time. We
> also run some VB/ADO apps, these run reasonably well, until one starts
> SQL*Plus then these two run slowly.
>
> A summary of the buggering around to date, the same SQL scripts take
similar
> times running under SQL*Plus and VB/ADO, running scripts locally or the
> network make no difference. The our initial storage parameters were not
> ideal, but moving them around has not had a significant effect, shifting
the
> SGA parameters to huge does nothing.
>
> I suspect there are some NT/Oracle settings which I don't know about, any
> ideas gratefully appreciated. Are there any QUE type books out there
which
> deal with running Oracle 7 under NT ?
>
> At this point, an axe seems like it would be a usefull programming tool !
>
> David Mortimer
>
>
Received on Mon Jan 17 2000 - 17:45:34 CST