Re: "DB Link are Inherently Slow" -- True or False?

From: Howard Latham <>
Date: Tue, 15 Jul 2008 15:42:39 +0100
Message-ID: <>

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 <>:

> 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

Received on Tue Jul 15 2008 - 09:42:39 CDT

Original text of this message