Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Poor performance on bulk transfer across db link -- wrapup

Re: Poor performance on bulk transfer across db link -- wrapup

From: Finn Jorgensen <finn.oracledba_at_gmail.com>
Date: Thu, 8 Nov 2007 15:37:39 -0500
Message-ID: <74f79c6b0711081237j3754011dy25714868d0851fb3@mail.gmail.com>


Are all the tables slow to transfer? Or just the big ones? Do any of them have CLOBs/BLOBs?

What's your OS?

Finn

On 11/8/07, David Aldridge <david_at_david-aldridge.com> wrote:
>
> Thanks to everyone who responded.
>
> We did a bunch of testing on changing SDU, but aren't able to change the
> MTU due to the impact on other production systems. Reducing the SDU to match
> the MTU produced no performance change. DB Links just seem to be problematic
> for performance, maybe due to something in our own environment, but our
> timeline doesn't give us the opportunity to investigate further..
>
> We're looking at other solutions -- transportable talespaces, in fact.
>
> Thanks again.
>

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Nov 08 2007 - 14:37:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US