parallel hint with group by gives wrong results

From: John D Parker <orclwzrd_at_yahoo.com>
Date: Thu, 20 Dec 2007 11:53:48 -0800 (PST)
Message-ID: <14465.72991.qm@web32601.mail.mud.yahoo.com>

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.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Dec 20 2007 - 13:53:48 CST