Re: Performance DB-Link

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Mon, 10 Nov 2003 02:13:53 +0200
Message-ID: <3faed842_1@news.estpak.ee>

Hi!

Try to keep amount of data transferred over network as small as possible. If you need data from remote database, query it in few big sets instead several small ones.
Use views for pre-joining remote tables. Put SDU (session transfer unit) to max value in sqlnet.ora. Tune network MTU (maximum transfer unit in TCP) to max value (about 8k if using ethernet jumbo frames for example).

Tanel.

"Arne Bippes" <sceddie_at_gmx.de> wrote in message news:ddad38c.0310290511.793e4f11_at_posting.google.com...
> Hi,
>
> we are thinking about using Oracles DB_link feature to connect two
> Databases.
> Currently the data is transported via MQSeries.
>
> Does anybody have any experience about the Performance. Do I have to
> expect increased or decreased Performance?
>
> Greetings
>
> Arne Bippes
Received on Sun Nov 09 2003 - 18:13:53 CST