Performance of DB Link VS Public Synonyms
957134Dec 20 2012 — edited Dec 20 20121) In a single database(Oracle 9.2) , I have multiple schema say a, b ,c d ,e etc.Currently we are using public synonyms to access tables of other schema.There is a plan to split the database into two or three DB and to use db links instead of public synonyms.So what would be impact on performance?
2) In a same database for accessing multiple schema objects which one between DB link and Synonym is a better approach and why? How are the working mechanism for each of them?
Appreciate your quick response.