Poor SQL*Plus Performance with 7.3.4 running on NT

From: David Mortimer <david.mortimer_at_virgin.net>
Date: Mon, 17 Jan 2000 17:33:51 -0000
Message-ID: <85vjm8$3b3$1@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 - 11:33:51 CST