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

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 17 Jul 2008 11:22:40 +0300
Message-id: <487F0150.1050707@inter.net.il>

Working with dblinks can be slower as oracle does not know what happens in the other server and gets all the records back and then start selecting. That is why they have a hint called 'driving site' and I have seen huge difference in performance with this hint.

You are talking about data pump import.
Can you explain a little more on what you are doing?

Adar Yechiel
Rechovot, Israel

David Aldridge wrote:
> 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) :(
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 17 2008 - 03:22:40 CDT

This message: [ Message body ]
Next message: David Barbour: "Difference Between RMAN Incremental and Full Backups - Driving me Nuts!"
Previous message: Nigel Thomas: "Re: Sql Developer - Migration from Sql Server to Oracle Database"
In reply to: David Aldridge: ""DB Link are Inherently Slow" -- True or False?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message