Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Slow requests, synonyms over dblink

Gaétan FrancoeurNov 18 2005 — edited Nov 21 2005

Hi,

It seems that some of our SQL requests are very slow when we use synonyms created over dblinks. When we try directly like : select * from my_table@my_dblink it's much faster !

Any idea what could cause this behaviour ?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 19 2005

Added on Nov 18 2005

#general-database-discussions

3 comments

678 views