Re: A challenge...

From: Richard Senior <see_sig_for_address_at_r-senior.demon.co.uk>
Date: Sat, 2 Jan 1999 10:06:48 GMT
Message-ID: <F4xG3E.3F8@r-senior.demon.co.uk>

In article <368cd64d.0_at_139.134.5.33>,

"Steven James Ryan" <smirnow_at_bigpond.com> writes:

> About one in every 1000 insert transaction stalls (or ?) in the database -
> get response time peaks of 40 to 180 secs. -- WHY??

Two reasonably long shots:

Check your DNS setup. Failing DNS lookups can produce this type of stalling and 40-180s would be typical.
If you are running in archivelog mode, have you looked at how the redo log is getting archived. Do the delays correspond to log switching for example?

--
Regards,

Richard Senior
London, England

Mail: richard at r-senior dot demon dot co dot uk WWW : www.r-senior.demon.co.uk Received on Sat Jan 02 1999 - 04:06:48 CST