Re: Very slow dblink in Oracle 8.1.6

From: Marc Billiet <someone.overthere_at_living>
Date: Thu, 09 Nov 2000 06:42:27 GMT
Message-ID: <20001109.6422726@slu40xxx.hae.hydro.com>

It all depends on the exact query you are executing. Try hints like DRIVING SITE and NO MERGE, create views on database B, ... And of course it also depends on the network performance. I believe ther e
are also NET8 tuning possibilities, but I have no experience with this.

You should be able to find information on this in the Oracle manual (Distributed Databases).

Marc

>>>>>>>>>>>>>>>>>> Oorspronkelijk bericht <<<<<<<<<<<<<<<<<<

Op 2000-11-09, 1:40:59, schreef Piyush Mittal <mittals_at_my-deja.com> over

het thema Very slow dblink in Oracle 8.1.6:

> Hi all

> We have 2 databases : Database A and Database B.

> When I connect to database A and run a simple query, it returns in les
s
> than a second.

> When I connect to database B and execute the same query against
> database A through a dblink, it takes almost 30 seconds.

> We need the dblink badly to perform unions, minuses et all for data
> validation purposes.

> Any suggestions on where we should look to speed up the dblink ?

> Thanks very much.

> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 09 2000 - 00:42:27 CST