Re: SQL*Net & loopback connector

From: <chris_at_thedunscombes.f2s.com>
Date: Fri, 2 Jul 2004 09:19:17 +0100
Message-ID: <1088756357.40e51a8593bd7@webmail.freedom2surf.net>

Yes it will.
I believe there will be a very, very small performance benefit in favour of the ip address entry, but only in name resolution when the connection is first setup after that i.e. for all subsequent SQL*Net access, there will be no difference.

HTH Chris

Quoting solbeach_at_cox.net:

> Solaris OS
> Assume two instances, PROD & WRK, on the same system.
> 1) Will SQL*Net between these two DBs work with no cable plugged into the
> NIC?
> 2) Will a performance difference exist between tnsnames
> files; where one has the actual hostname & the other where
> "127.0.0.0" replaces the hostname?
> [i.e. host=systema vs. host=127.0.0.0]
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
>

Chris Dunscombe

Christallize Ltd

Everyone should have http://www.freedom2surf.net/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 03:16:00 CDT