Re: "DB Link are Inherently Slow" -- True or False?
- From: "Howard Latham" <howard.latham@xxxxxxxxx>
- To: david@xxxxxxxxxxxxxxxxxx
- 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
2. Code
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@xxxxxxxxxxxxxxxxxx>:
> 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
Other related posts:
