AW: Re: Using dblinks over distance

we use dblink to exchange data between many databases hosted in Europe (Data amount > 20 TB). Every things work fine (there is some limitations but still now every things work fine).
However currently all our customers have the databases servers on the same location (luckily).
We will see when one of them decides to use different locations (for example Europe/Asia). Maybe in this case would the cloud save our jobs

regards
Ahmed Fikri

• Original-Nachricht --- Von: Mladen Gogala Betreff: Re: Using dblinks over distance Datum: 13.01.2020, 13:40 Uhr An: oracle-l_at_freelists.org

There are other solutions, too: materialized views cache data locally and speed up selects. Replication can finish the update locally and then propagate it to remote site in the background, without users waiting.

On 1/13/20 3:20 AM, Andy Sayer wrote:
> You have a few options:
> Make the distance between DBs closer (migrate the non cloud to the
> same data centre, or migrate the cloud back to your premises).
> Increase the signal velocity (better cables, fibre optics...)
> Increase the possible bandwidth (more routes, better fibre optics...)
> Utilise more of the bandwidth you have available (change your code to
> work so it is less chatty across the link - see where most of the chat
> is coming from and start from there, favour anything but nested loop
> joins from one DB to the other)

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--
http://www.freelists.org/webpage/oracle-l
<http://www.freelists.org/webpage/oracle-l>



--
http://www.freelists.org/webpage/oracle-l