Re: parallel query

From: Jim Kennedy <odysscci_at_teleport.com>
Date: Wed, 8 Feb 1995 11:46:18
Message-ID: <odysscci.139.000BC5E2_at_teleport.com>


In article <3h0qgt$lbc_at_eccdb1.pms.ford.com> alal1_at_PROBLEM_WITH_INEWS_GATEWAY_FILE (Anuj Lal) writes:
>Path: news.teleport.com!rainrgnews0!psgrain!reuter.cse.ogi.edu!uwm.edu!math.ohio-state.edu!howland.reston.ans.net!agate!newsxfer.itd.umich.edu!jobone!fiesta.srl.ford.com!eccdb1.pms.ford.com!alal1
>From: alal1_at_PROBLEM_WITH_INEWS_GATEWAY_FILE (Anuj Lal)
>Newsgroups: comp.databases.oracle
>Subject: parallel query
>Date: 4 Feb 1995 21:10:53 GMT
>Organization: Ford Motor Co.
>Lines: 11
>Message-ID: <3h0qgt$lbc_at_eccdb1.pms.ford.com>
>NNTP-Posting-Host: eccdb1.pms.ford.com
>X-Newsreader: TIN [version 1.1 PL6]

>I heard oracle 7.1 has parallel query option.
> I have single query which has process table with 10 million rows
>and fetch around 50000 rows.
> How can I use the paralle query option for this query.
> Do i have to declare different cursor for each process fetching data
>from same table.
>Thanks
>alal1_at_eccdb1.pms.ford.com

No, while I have not tried it, the documentation claims that you need to specify it as a hint and/or as a parameter when you create the table. It handles the parellell query. Suppossedly, it will break up the query and have several processes do the work. Such as a full table scan can be divied up between n processes. It appears that you do not need to do much if anything in your application to make it work. They do caution that it may not help - for example you have one very slow disk with all the data. You can see where the bottleneck is. How well does it work? I do not know. It is described in the on-line help in the file svadd.hlp if you have Windoze.  Otherwise I assume it is in the manual, if you have one.

Jim Kennedy Received on Wed Feb 08 1995 - 11:46:18 CET

Original text of this message