Re: "DB Link are Inherently Slow" -- True or False?
Date: Tue, 15 Jul 2008 15:42:39 +0100
DB Links can be slow -or slow down processing - and for two reasons - 1. Network is Slow
Some code is slowed down badly by using a DB Link. I'm not sure why by some
apps really suffer
while others don't I think it's to with what is is happening in which database.
On the OTHER HAND COPY over a DBLINK can be VERY VERY FAST! and therefore one of the best ways for bulk transfer of data.
2008/7/15 David Aldridge <david_at_david-aldridge.com>:
> I am being persistently told by a DBA that DB links are inherently slow
> and not suited to bulk transfer of data.
> Does anyone have any experiences to share on the sort of practical
> MBytes/sec throughput we ought to be getting on a 10GBit network between two
> databases having no intervening firewalls, routers, or other potentially
> performance limiting network components? We're seeing 2MBytes/sec using data
> pump import in network mode with parallelsim of 10 (ie. sourcing data
> through a db link from another db on a different host) :(
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Tue Jul 15 2008 - 09:42:39 CDT