From: jal@esc188.expansion.com
Subject: Re: Urgent: DBLink problem
Date: 1998/09/09
Message-ID: <6t6v3f$o31$1@ash.prod.itd.earthlink.net>#1/1
Distribution: world
X-Posted-Path-Was: not-for-mail
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: Wed Sep  9 15:22:39 1998
Organization: Expansion.com
Mime-Version: 1.0
Newsgroups: comp.databases.oracle.server


In article <35F3EAA7.32F0BC69@bart.inescn.pt>, Marco Ribeiro <mar@bart.inescn.pt> 
writes:

>Hi,
>
>We've got two databases physically 
>separated, we've also got a dblink
>connecting the two databases.
>
>When we load data from the remote 
>database to the central database 
>the
>process is very fast but when we 
>make remote calls to functions 
>while
>load data the process becomes 
>extremely slow.
>
>Any ideas ?
>
>Thanks,
>
>Marco
>
>

Hello,

I am doing something very similar where my HOST (instance 1) machine is calling 
remote procedures to insert JOB Queue records and call procedures to update 
tables.
On the first run it is very slow, however the consecutive runs are relatively 
faster. I am not a DB (yet) I would imagine it has something to do with the Pre-
Parse and process phase in Oracle.

Putting your Update or Insert in the Remote SGA may speed this up as it does not 
have to parse your statement. Something to look at

Sincerely,

Jason Ladew