Team members,
we have db1 database and db2 database.On db2 database we have synonyms created for objects
on db1 database through database links.We are using this synonyms in a procedure in db2 which calls procedure
in db1 for insertions and deletions in db1.when we execute this procedures in db2 the result takes quite a while
i.e min 1hr.I dont know what need to be done to improve -this thro remote updations.Guys could u pls advice me on this
Oracle 8.1.5 on solaris 2.6