Re: HELP! Parallel query problem

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 27 May 1999 22:23:11 +0100
Message-ID: <927840482.26494.0.nnrp-11.9e984b29@news.demon.co.uk>

Have you tried setting parallel_max_servers back to 8.

How many partitions in the table ?
How many partitions would be relevant to the hint ? Are there any other parameters you changed at the same time ?

In the first fast run had you used 'alter session' to change any performance-related parameters ?

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

kal121_at_yahoo.com wrote in message <7ika29$86d$1_at_nnrp1.deja.com>...
>Hello all,
>
>Here is a very strange problem:
>
>I was running a query with the following hint:
>/*+ ORDERED PARALLEL (r, 16) */
>
>init.ora has:
>parallel_min_servers = 2
>parallel_max_servers = 8
>
>The query is running against a partitioned table.
>Using this hint and partitioning, it ran at 1.3 minutes (which is great,
>considering it used to run at 20 minutes!)
Received on Thu May 27 1999 - 16:23:11 CDT