Re: Connection delays causing problems.

Charles Hooper wrote:
> Maxim Demenko wrote:
> > Ed Prochak schrieb:
> > > The problem: ORACLE connections sometimes take tens of seconds to come
> > > up. This is true whether the connection is via sqlplus, ACCELL
> > > application program, or thru JAVA web application program.
> > >

[]
> >
> > The most common causes of such delays, which i know - are the DNS
> > issues. You should check your nsswitch.conf, resolv.conf and hosts
> > files. Maybe , however , you don't see any obvious misconfiguration -
> > then you should probably trace. An excellent document how to read Net 8
> > trace file is the Note 156485.1
> >
> > Best regards
> >
> > Maxim
>
> If he is running into DNS problems, he should be able to use Ethereal
> on his Linux boxes to see where the packets are going, and what the
> responses to those packets are.
>
> In dedicated server mode, the listener on Linux/Unix tries to spawn an
> additional process when a client connects - this may account for some
> of the delay. Did you adjust the kernel memory parameters? What does
> the following show at a prompt:
> cat /etc/sysctl.conf
>
> Charles Hooper
> PC Support Specialist
> K&M Machine-Fabricating, Inc.

Thanks for the info guys. That was the track we were pursuing. But I found out from our DBA this morning that they found a faulty bit of hardware in the connection to the network storage. (sorry, I didn't get the exact detail of what the part was).

So things are much better today. Thanks again for the help.

Ed.
(of course just as I wrote that a group of emails came in with Oracle errors. But these aren't connection related. Time to get back to work!) Received on Tue Jul 18 2006 - 14:10:53 CDT