Re: Slow connection time 7.3.4

Hi,

I don't know if there is an truss equivalent on NT. if there is, trace your sessions. Also, you can do:

• check response time in ping, tnsping
• set sql*net client,server,listener trace in level 16

When I trussed O734 on unix, I had seen that otrace was the problem. After I removed otrace files, problem had been solved.

hope this helps...

"Tim Shute" <tshute_at_nisoft.com> wrote in message news:<5a38bcce84099c8b8ba221f554a157fa.46509_at_mygate.mailgate.org>...
> "Niels van de Coevering" <Niels_van_de_Coevering_at_wistron.nl> wrote in message
> news:3c3429c1$0$218$4d4ebb8e_at_news.nl.uu.net...
>
> > We have several Oracle 7.3.4 databases running here on NT 4. All are running
> > well, except this one where we have a problem with connecting to the
> > database. It takes a very long time to connect to it. There are no other
> > users connected to this database.
> >
> > Does anyone know what the problem might be and how I can solve it?
> >
> > Thanks,
> > Niels
>
>
> Check the Host parameters in the SQL*Net easy config.
>
> If you are using the machine name then your name resolution might be the
> bottleneck.
> Check this by doing a PING in a command window and look at the response times.
>
> You could also change the Host value to the actual IP address of the server.
>
> Tim.
> ==
Received on Thu Jan 03 2002 - 11:47:03 CST