Oracle 7.3.2.3 "pause" problem

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 Received on Thu Apr 23 1998 - 06:42:05 CDT