Re: Parallelise Function call

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sat, 08 May 2010 16:31:53 +0200
Message-ID: <84lav3FvlaU1_at_mid.individual.net>



On 08.05.2010 10:49, valigula wrote:
> I need to run a function/procedure/script using a dblink between two
> servers.
> The query itself uses two views on the remote server, the views are
> only effectives when passing 1 paramente, I need to run 20 k (ish). As

I do not know how to "pass a parameter to a view". I know only how to pass parameters to a function or maybe a view definition. What are you trying to do?

> an interim solution i create a function that do the select one at the
> time , but the time consuming it is quiet large and thinking on
> turning it, I was suggested to parallelise the function call within
> the select. But not really clear in how to do that.
>
> Any ideas or suggestions wil be appretiatte

Please provide the version or Oracle you are working with as well as the schema. From what you wrote it is not clear to me what exactly you are trying to do.

As a first general idea: if you need to join the two remote views why not create a third view for the join on the remote machine and query that?

Kind regards

        robert

-- 
remember.guy do |as, often| as.you_can - without end
http://blog.rubybestpractices.com/
Received on Sat May 08 2010 - 09:31:53 CDT

Original text of this message