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

From: Howard Latham <howard.latham_at_gmail.com>
Date: Tue, 15 Jul 2008 15:42:39 +0100
Message-ID: <713d96d10807150742t400b8675h91e48d890e79e695@mail.gmail.com>


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_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-l
Received on Tue Jul 15 2008 - 09:42:39 CDT

Original text of this message