That really depends... Are you writing queries that can (or at least
should) be run on the remote machine exclusively? Or are you joining
remote data with local data?

Justin Cave
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC

-----Original Message-----
From: Chad Smith
[mailto:oracledba-ezmlmshield-x60422830.[Email address protected]
Sent: Wednesday, September 07, 2005 3: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