Re: Parallel Query

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)..... Received on Mon Apr 10 2000 - 00:00:00 CDT