Re: Concurrent/Parallel Execution

From: gazzag <gareth_at_jamms.org>
Date: 22 Nov 2006 09:03:18 -0800
Message-ID: <1164214998.191355.123980@h54g2000cwb.googlegroups.com>

ihb wrote:
> Question is about Concurrent/Parallel Execution -
>
> Say data is everywhere....there are n databases (on n servers)
> In app I need to query each DB and COMBINE the results.
>
> First, is it even possible to do this (i.e. parallellism) ???
>
> Is Oracle's "Parallel Query" http://orafaq.com/faqopq.htm
> a way to achieve such concurrency.
>
> If not, then what does it take ?
>
> thanks !

Look into "database links":

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements009.htm#sthref749

HTH -g Received on Wed Nov 22 2006 - 11:03:18 CST