Why
SQL*Net connection is slow?
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?
Ans:
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.