Re: database links and performance

  • From: mhthomas <qnxodba@xxxxxxxxx>
  • To: jdunn@xxxxxxxxx
  • Date: Wed, 9 Feb 2005 00:15:38 -0500

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@xxxxxxxxx> 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?
> 
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l

Other related posts: