Skip to Main Content

Improve the performance speed of Oracle with pushing data to a remote server using a DB link

3251409Oct 21 2016 — edited Oct 21 2016


Recently I have been trying to figure out ways to improve the performance of a concurrent program that moves data over to another server using a DB link. In the past the concurrent program would update all of the records on remote database within 30 minutes. Now the concurrent program runs for hours as our databases have become quite large in size. Any suggestions on how to improve the speed of the information being pushed over to the remote database?


Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Nov 18 2016
Added on Oct 21 2016