Re: HELP: What are the advantages of Parallel Query/Server

Francisco Lameira wrote:

> Hi,
>
> I'm using Oracle 7.1.6 on a Alpha (1 processor, 40 disks of 4.3 GB).
>
> - What is Parallel Query? And Parallel Server?
>
> - Can the performance of my DB (with 1 processor) be improved with the
>
> use of any of these options? In what way?
>
> Thankx in advance.

By the way, you probably won't see much of an improvement by implementing Parallel Query Server on your system: Oracle 7.1.6 , though it does support the parallel query option ( you can add the init parameters and get the thing running ) will really not work properly.

You really need to explicitly code your SQL statements to make use of the Parallel query option. Otherwise the database won't take advantage of the Query serversThe syntax is in the book. In most cases, you really can't re-write your SQL/application.

You will get more or an improvement if you can upgrade to Oracle 7.2.2 and above. These versions of Oracle ( if Parallel Query is implemented ) "automatically" utilize the parallel query servers if it will improve the performance/query execution time.This is with "no" code changes. This way , a lot of existing or older applications can benefit from the new functionality without a big re-write. If you have enough memory, the upgrade to 7.2.2 + and the parallel query implementation should cause a noticeable increase in performance/execution time.

The Parallel Server option is another story. As explained by the others, you need another server for that one.

Hope this helps Received on Wed Jun 25 1997 - 00:00:00 CDT