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