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

If I may be so bold as to tack on to Tim's point (perhaps adding another $0.02), what about support of any process over a network? If using some method to extract to flat file, compress, sftp / scp / ..., uncompress and load, you've got a large number of points of failure and perhaps rather complex code to allow for restarts. With dblinks the previous scenario becomes less complex and, IMHO, easier to support.

In the end, your best bet with the DBA would be for him to prove it. Show you why one way is better than another in terms of performance.

Dave

Dave Herring, DBA | A c x i o m M I C S / C S O

630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman Sent: Tuesday, July 15, 2008 12:01 PM
To: mark.powell_at_eds.com
Cc: Oracle List
Subject: RE: "DB Link are Inherently Slow" -- True or False?

Another important consideration is transactional integrity and data accuracy. You get that with database links, but not with export/import, unload/load, etc. Faster is less useful if its less reliable... ;-)

Just chiming in with another US$0.02...

Quoting "Powell, Mark D" <mark.powell_at_eds.com>:

> Slow is a relative term. If the alternate transfer method is an
export,
> FTP, and import then even if the insert select across the link was
> slower than the import step it is likely to be faster than the
combined
> exp/imp or exp/FTP/imp process.
>
> The real question is how important is the transfer speed? How often
> will the transfer need to be performed? Will the receiving object
need
> to be re-created, cleared out prior to the task or will the data need
to
> be merged? If the data is merged what are the chances of getting an
> error?
>
> The answers to these questions should allow you to choose the best
> solution for your needs.

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


*************************************************************************
The information contained in this communication is confidential, is
intended only for the use of the recipient named above, and may be
legally privileged.

If the reader of this message is not the intended recipient, you are 
hereby notified that any dissemination, distribution or copying of this
communication is strictly prohibited.

If you have received this communication in error, please resend this
communication to the sender and delete the original message or any copy
of it from your computer system.

Thank you.
*************************************************************************

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