Re: Very slow dblink in Oracle 8.1.6

From: I.A. Saez <i.a.saez.scheihing_at_tue.nl>
Date: Thu, 09 Nov 2000 09:07:42 +0100
Message-ID: <3A0A5B4E.DD94C9B5@tue.nl>

Piyush,

Are you using MTS (Multithreaded Server)? If so, try a dedicated connection.

kind regards,

Ivan

Piyush Mittal wrote:
>
> 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 less
> 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 - 02:07:42 CST