Re: Database links

Are the database links pointing using a tnsnames.ora entry which specifies a tcp link, and is that tcp link using a loopback ip address or an external ip address.

In either case, the data will be passing through some layers of the network software.

On a UNIX box, you could use

    netstat -I lo0 1
(lo0 is the usual name for the loopback tcp system, 1 for snapshots at 1 second intervals) to check that your data are going through the loopback. I don't know what the NT equivalent is.

The loopback is not so bad as a full network out and in. the MTU is usually much larger (8K or 16K instead of 1500 bytes or so) , and the turnaround time is much shorter - often by a factor of 3 or 4.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Steve B wrote in message <7koaub$6sb$1_at_taliesin.netcom.net.uk>...
>I've a link between two Oracle8i instances, both of which are on the same
NT
>box. Can someone please confirm that data is NOT transferred from one to
>another via a network trip..as would be the case if the instances were on 2
>seperate machines..
>
>Also...has anyone experiences of data transfer across links slowing down
>applications..
Received on Tue Jun 22 1999 - 11:57:24 CDT