Unanswered: Oracle Database Link Performance Question
I have used the database link to compare the records between Database A and B before perform deletion of records in Database A. To have better performance, should the script connect to database A then call database link to database B or the opposite way? Appreciate advice from the expert here. Thanks a lot.
Database Link performance is dependent on the network and not of the database. More high speed the interconnect between the databases is, better will be the db link performance whichever way you may operate.