Re: Oracle 7.3.2.3 "pause" problem

What is your platform? If it is NT, then you could be seeing disk flushes from the inserts.

As to an internal ORACLE pause, it could be that the re-indexing that occurs to rebalance the b-tree when the keys/leaves get out of balance.

In article <6hn9b7$10ia$1_at_rtpnews.raleigh.ibm.com>,   "Jim Morgan" <jimmorgan_at_csi.com> wrote:
>
> We have an application which does heavy-duty real-time updates from
> TCP/IP-connected clients. We see rates of better than 30 updates per second
> with the tuning we have done, but we also have noticed that when the
> database is being hit VERY hard (like when all clients were down for a long
> time and then they are brought online...their transactions are queued and
> then we really start to fly!) that we get our best throughput times with
> Oracle.
>
> We also notice that sometimes Oracle "takes a break" and just sits there,
> not processing transactions, for 2 minutes or more. We cannot even start an
> SQL*PLUS session when this happens. So if we attempt to start an SQL*PLUS
> session when this happens, it just displays the first message and hangs
> before getting the SQL*PLUS prompt. After a little while, we finally get
> the SQL*PLUS prompt, at which time our db application begins running very
> rapidly again.
>
> Anyone know what might be able to explain this behavior? We know we will
> have some variance with the TCP/IP connected clients, but remember that we
> cannot even start an SQL*PLUS session when this happens, so I do not think
> that is the problem we are seeing.
>
> --
> Regards,
> Jim
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Apr 24 1998 - 16:52:53 CDT