No version details..Assume 10gR2.. If yes you are probably hitting
some interesting bugs are hash aggregation.. Does your plan have 'HASH
GROUP BY'?
-Gopal
On Dec 20, 2007 11:53 AM, John D Parker <orclwzrd_at_yahoo.com> wrote:
> query with no parallel hint and parallel degree 7 set on some of the
> tables(including table that is hinted) gives right answer but is "too slow"
>
> query with parallel hint and no specified degree(ie default degree) and
> parallel degree 7 set on some of the tables(including table that is hinted)
> gives wrong answer by factor of default degree and is fast enough.
>
> The query has a sum and a group by, the sum is off by multiple of the
> default degree(24) when the parallel hint is given. Anyone know about any
> "features" relating to sum/group by/parallel hint/default degree.
>
> all help welcome.
>
> john
>
>
> ________________________________
> Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it
> now.
>
>
--
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 20 2007 - 21:56:48 CST
