Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Parallel querying with partitioned table

Re: Parallel querying with partitioned table

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 24 Jun 2007 07:25:43 +0100
Message-ID: <QPednW2gqJ7qk-PbRVnytAA@bt.com>

<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.html
Received on Sun Jun 24 2007 - 01:25:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US