Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel querying with partitioned table
<yong321_at_yahoo.com> wrote in message
news:1182660308.546819.120970_at_z28g2000prd.googlegroups.com...
>
> [I caught you top-post, Jonathan!]
"Top-posting" wasn't a sin when I started using the newsgroups, and it's more appropriate for email - so sometimes I forget.
>
> Would setting parallel_adaptive_multi_user to false get us closer to
> the M=N goal?
No.
> Documentation says there's no way to tell Oracle to use
> block range granules instead of partition granules, or the other way.
> Any comment?
>
Where did you find this comment in the documentation, I hadn't come across it.
For some special cases the pq_distribute() hint - for parallel joins - will have an effect.
> Unrelated. Why is the much touted parallel_automatic_tuning deprecated
> in 10g? Is it against Oracle's trend of increasing auto-tuning, or
> it's because all the implied changes (message size doubled etc)
> already default?
>
I hadn't realised that parallel_automatic_tuning was "much touted". Most of the comments I've heard about it have been negative - mostly because it sets parallel_adaptive_multi_user to true when you enable it.
Your guess is as good as mine. The feature may be deprecated because Oracle wants to leave it 'always on' in future.
> Yong Huang
>
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Sun Jun 24 2007 - 01:25:43 CDT