From: Brad Odland <bodland@execpc.com>
Subject: Re: Parallel Query
Date: 2000/04/10
Message-ID: <38f21be9$0$26047@news.execpc.com>#1/1
Content-Transfer-Encoding: 7bit
References: <38ED3814.6509FC9A@computer.org>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@execpc.com
X-Trace: Tl\okXWcmLGI5[332>a9YKbfNiaEHUgJGRYcgIRLSUEMBdld1DNZn]NNIiR_Tf@QkKfYe`D?iVhXKB\l`9`CTo_E923dmEA141A
Organization: ExecPC Internet - Milwaukee, WI
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server


Jay Walters wrote:

> Does parallel use anything like ratios of partitions to degree of
> parallelism, or number of devices on which a table is spread across to
> decide if it should be parallelizing an operation?  I'm having a hard
> time getting a statement parallelized even though the optimizer is doing
> all the right steps with regards to full partition joins, etc; just
> doing the steps serially instead of in parallel.
>
> Cheers

You  need to set the init.ora parmeters  to spawn parallel query servers
(minimum and max_parallel and correctly set a degree of parallel on the
tables in the query the optimizer should be choose and statistics run on
all tables....There is quite a bit to this you best read Chapter 19 of the
Oracle 8 Tuning (in oracle 8 online docs).....