Depends on what you are doing.

Joins and large data transfers between databases could be slow depending
on the network you have between the systems. Also it depends on how the
query is created. Expecting multiple large full table scans over a
database link could be slow. There are ways to optimize this situation.

If you are just running a query on a remote DB and the result set is
small, then for all intents and purposes, you won't notice a performance
issue because of using the link.

-----Original Message-----
From: Chad Smith
[mailto:oracledba-ezmlmshield-x60422830.[Email address protected]
Sent: Wednesday, September 07, 2005 12:40 PM
To: LazyDBA Discussion
Subject: Database Link Overhead


Does anyone have experience running queries (medium-to-long running)
over database links? I am curious what the performance impact and
overhead associated I could expect.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page