Re: Why? Oracle 7.3 Server stalls Client

Sounds like your redo logs are filling up. Try increasing the size of your redo logs and see if your throughput improves. You didn't say how often you commit. Do you commit after each insert?

Stevyn Dembo wrote:

> Hello.
> We are running oracle 7.3.3 on Windows NT3.51/P266/64MB memory/2 disks. We
> have written a tiny looping program in Delphi on a W95 client to see how
> many inserts per minute we can make into a single table (2 columns, primary
> key index, no relations, no triggers). The network is TCP/IP. We want to
> achieve the maximum insert rate that is achievable for a single client
> against the db. We have observed the following situation. The driving
> program runs at full speed for about 200 inserts and then stalls. There is
> a bunch of disk activity on server after the stall, and once the server
> disk activity has subsided, the driving program resumes and sends another
> approx. 200 inserts, stalls,server disk activity, on and on! We have
> monitored the network packets and have observed that no packets are being
> sent during the stall. Stalls are approximately .5 - 1 sec.
>
> The BIG QUESTION is: What steps can we take to eliminate or minimize this
> stalling? Currently we can achieve an insert rate of about 4000-4600
> inserts per minute. Without the stalls, we could almost double the rate.
>
> Thanks in advance to anyone who may have suggestions as to how to resolve
> this issue!!
> Regards.
> Stevyn Dembo
> steve_dembo_at_bc.sympatico.ca
Received on Fri Jul 17 1998 - 09:03:12 CDT