Re: database links and performance

Hi John,

I'll take a different approach than the other replies. You have some good replies so far.

If you really care about performance of database links, its essential you learn how to trace the performance on both ends of each link. Then, if you see a problem (I've still got unexplained wonders that bother me at night... unresolved... you get the idea) you can trace and explain plan everything and track down any issues or bugs or settings.

Tracing both ends can be non-obvious, and I have not got all the details worked out as well as I'd like. If anyone can point me to a 'good' link, thanks.

Regards,

Mike Thomas

On Tue, 8 Feb 2005 14:39:50 -0000, John Dunn <jdunn_at_sefas.com> wrote:
> We are considering using database links in Oracle 9i but are concerned about
> performance.
>
> Presumably the network can be a bottleneck when using database links.
>
> Does anyone have any useful experiences with performance of database links?
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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