Using dblinks over distance
From: Cohen, Andrew M. <Andrew.Cohen_at_tufts.edu>
Date: Thu, 9 Jan 2020 18:27:53 +0000
Message-ID: <SN6PR05MB41762E1BAE9BDD4B6B743D7A8A390_at_SN6PR05MB4176.namprd05.prod.outlook.com>
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.
Date: Thu, 9 Jan 2020 18:27:53 +0000
Message-ID: <SN6PR05MB41762E1BAE9BDD4B6B743D7A8A390_at_SN6PR05MB4176.namprd05.prod.outlook.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 09 2020 - 19:27:53 CET