Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with remote procedure calls

Re: Problem with remote procedure calls

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Thu, 10 Sep 1998 08:29:53 +0200
Message-ID: <35F771E1.1E7AFF21@datenrevision.de>


Hi, Marco,
maybe your procedure call involves a join for some large tables? In this case I'm not sure, wether the original tables are moved over the network to your local database before the resulting set is created. This would possibly take a lot of time.

Rolf

Marco Ribeiro wrote:
>
> Hi,
>
> When I make a remote call to a function this function takes a lot of
> time to execute but if I execute this function locally It's very fast.
>
> Any ideas.
>
> Thanks
Received on Thu Sep 10 1998 - 01:29:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US