Re: Concurrent/Parallel Execution

From: sybrandb <sybrandb_at_gmail.com>
Date: 22 Nov 2006 07:33:57 -0800
Message-ID: <1164209637.620159.159230@k70g2000cwa.googlegroups.com>

On Nov 22, 4:23 pm, "ihb" <e..._at_email.com> 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 !

Parallel Query is about a query in *one* database being split up in several sessions.
If you have n databases on n servers, you are grossly misusing Oracle (probably because you never read any manual) and it takes an army of consultants to clean out your mess!

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Wed Nov 22 2006 - 09:33:57 CST