Re: Using dblinks over distance

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 Received on Thu Jan 09 2020 - 20:39:09 CET