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

Many Thanks - This got the machine running at an acceptable speed. It put me on the right track, I'd spent toom much time looking for an NT specific solution/analysis.

David Mortimer

Bert Scalzo <bscalzo_at_home.com> wrote in message news:yQNg4.3044$k25.310224_at_news1.rdc2.tx.home.com...
> 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 Tue Jan 18 2000 - 11:25:26 CST