Re: SQLNet connects are slow on NT 4

Hi David,
make sure in %oracle_home%\network\admin\sqlnet.ora automatic_ipc = OFF (if you are not on the server) and
names.directory_client=(tnsnames, onames) or (tnsnames) if you don't use Oracle Names.
What happens is in this case is sqlnet won't try to connect using ipc and will go for tnsnames.ora directly without searching for a nameserver.

Hth,

Sybrand Bakker, Oracle DBA

DSmith wrote:

> All,
>
> Does anyone know of a parameter, perhaps in the NT4 registry, that
> determines a wait interval for TCP connections?
>
> We are experiencing a small wait (~ .8 sec) when connecting to the DB via
> when initiating SQLNet 2.3 (TCP).
>
> Does anyone know how to precisely measure this connection time and tune
> SQLNet for faster connections?
>
> --David Smith
> dsmith_at_hpti.com

Received on Fri Mar 05 1999 - 11:21:57 CST