Re: Oracle tuning on Windows NT

An 8 meg SGA is pretty small. And, 95% inserts is really high. How come no disk activity with all those inserts? How big is the shared pool? Are you getting lots of reloads? If so, check to see if you are using bind variables in all cases. Use sql trace and tkprof to check this out. Also, you might have a really slow network. tcp/ip or netbeui? Ipx? Fast or slow ethernet? how many nodes, etc.? any network contention? Check NT's resource monitor. What are you competing with on the machine? Check the system setup and 'task switching' to make sure that foreground and background get the same priority. Just a few thought and stabs off the top of my head.

Roger

Brian M. Biggs <bbiggs_at_cincom.com> wrote in article <32E66973.1C62_at_cincom.com>...

> Now my real question: we are running a 16-bit Visual Basic 3.0
> application (through ODBC) against Oracle Workgroup Server 7.3.2.2.1 on
> a Windows NT 4.0 machine (dual Intel P166 CPUs). Performance is pretty
> bad with more than a single user, and even a single user operation takes
> about 1 minute. The particular operation is doing about 95% inserts.
Received on Wed Jan 22 1997 - 00:00:00 CST