Re: SQL*Net via MS TCP/IP-32 3.11a very slow

Carel-Jan Engel (cj.engel_at_ease.nl) writes:  

> I called Oracle Technical Support. They gave me this solution:
> add a line to the 'hosts' file in the windows directory:

   I've used the same trick. Hardcoding the IP address in the tnsnames.ini file (in place of the host or Oracle Names) is even faster. The culprit is Microsoft's abysmally slow DNS lookups.

--
   - Doug Harris
     IS Project Leader, Prices Division,
     Statistics Canada.        ## WHERE ALL_OPINIONS.OWNER = USER ##