Re: HELP : Parallel Query Problem

Hello,

Lets look for your processors activity. It's possible that you have to small count of processor for parallel_max_servers=16 and parallel query processes haven't processor time. I'm not sure but try again with parallel_max_servers=8.

Rafal

In article <7j11tg$96a$1_at_nnrp1.deja.com>,   kal121_at_yahoo.com wrote:
> 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!)
>
> So, just for fun, I set max_servers to 32 in both the hint and the
> init.ora file. Well, the query didn't do so hot - so I shut down
Oracle
> and restarted it with parallel_max_servers set back to 16 and
> changed the hint to use 16 also.
>
> I fully expected the query to perform back at 1.3 minutes as it had
> previously. Well, it didn't! Now it's running at 4 minutes and it
won't
> budge. I've restarted my machine (WinNT 4.0). Nothing. Still 4
> minutes. I've dropped the partitioned table, rebuilt the partitions.
> Still 4 minutes!
>
> So what happened here??? Please help. Desperate.
>
> Thanks.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 02 1999 - 09:25:47 CDT