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
------------------------------------------------------------------------
Gesendet mit der Telekom Mail App
<https://kommunikationsdienste.t-online.de/redirects/email_app_android_sendmail_footer>
--- Original-Nachricht ---
Von: Mladen Gogala
Betreff: Re: Using dblinks over distance
Datum: 13.01.2020, 13:40 Uhr
An: oracle-l@xxxxxxxxxxxxx
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)