Re: Using dblinks over distance

Not really. If you are going over the internet, regardless of your connection speed, you will hit bottlenecks due to the competition will millions of others (across a 1000 miles). What Mladen is referring to is purchasing dedicated bandwith between the 2 locations, and thus, getting far more guaranteed speeds and latency.

On Fri, 10 Jan 2020, 02:40 Vishal Gupta, <vishal_at_vishalgupta.com> wrote:

> Problem of slow response over database link to a database situation at
> 1000+ miles distance is indeed distance (i.e. network latency), not speed.
>
>
>
> Regards,
>
> Vishal Gupta
>
>
>
> *From: *<oracle-l-bounce_at_freelists.org> on behalf of Mladen Gogala <
> gogala.mladen_at_gmail.com>
> *Reply-To: *<gogala.mladen_at_gmail.com>
> *Date: *Thursday, 9 January 2020 at 18:41
> *To: *<oracle-l_at_freelists.org>
> *Subject: *Re: Using dblinks over distance
>
>
>
> The problem is not the distance, the problem is the network speed. WAN is
> usually slightly slower than 10Gb LAN. Thus the solution: improve the
> network speed. Buy more dedicated lines from your network provider. Also,
> it's about the application design: you shouldn't do real time queries
> against the database in the server room far, far away. You should use
> materialized views and cache the data locally. It's called "intelligent
> design".
>
> On 1/9/20 1:27 PM, Cohen, Andrew M. wrote:
>
> As we move some of our database VMs to the cloud we have come across the
> following situation where the database links between databases (which used
> to be all on prem) are now being attempted over thousands of miles. This
> has caused extremely poor performance. We have found that an arraysize
> session parameter assists with some of the select statements, but updates
> which use links to get data don’t seem to perform any better with this
> arraysize parameter. To make matters more complicated, we are making these
> calls in PeopleSoft applications.
>
>
>
> We’re using Oracle 18 and 19 databases on Rhel 7 mostly.
>
>
>
> Does anyone have any suggestions as to how to improve performance using
> database links over distance?
>
>
>
> Thanks,
>
> Andy
>
> --
>
> Mladen Gogala
>
> Database Consultant
>
> Tel: (347) 321-1217
>
>

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