Database Link Question
From: James W. Howe <james.howe_at_see.signature>
Date: Mon, 28 Jun 1999 03:55:54 GMT
Message-ID: <3776f0da.1425339_at_gustav>
I'm working with a database which is linked to another database located on another server. We have implemented synonyms to allow programs to access remote tables without having to know that they aren't local. However, this raises a question. If I have a program which is performing selects and other operations on the remote table, will this necessarily mean that every record in the table from the remote database is sent over the network to our "local" machine so that it can be processed by the query or does Oracle have some way to have the query executed remotely? I would guess it's the former and not the latter. When working with linked databases, what is the best technique to keep network traffic to a minimum?
Date: Mon, 28 Jun 1999 03:55:54 GMT
Message-ID: <3776f0da.1425339_at_gustav>
I'm working with a database which is linked to another database located on another server. We have implemented synonyms to allow programs to access remote tables without having to know that they aren't local. However, this raises a question. If I have a program which is performing selects and other operations on the remote table, will this necessarily mean that every record in the table from the remote database is sent over the network to our "local" machine so that it can be processed by the query or does Oracle have some way to have the query executed remotely? I would guess it's the former and not the latter. When working with linked databases, what is the best technique to keep network traffic to a minimum?
Our "local" database is 8i and the "remote" database is 7.3 (I believe).
Any help anyone can offer on this subject would be appreciated.
Thanks.
Received on Mon Jun 28 1999 - 05:55:54 CEST