Wrong results don't give any ORA-600/7445 because they *do* give results which are wrong.
ORA-600/7445 don't give any results because internal self-assertions/segmentation violations causethe server process to crash before they can return any results. Such cases are best followed up with _test_cases_ with Oracle Support - present the simplest form of data and corresponding SQL which give the correct and incorrect results. In this case, it appears enabling/disabling hash-joins made the difference.Narrow the dataset down as much as you can to produce the incorrect results. In cases where I had to do this, I could narrow it down to less than 20 rows to produce the same effect. When you can do a reproducible test case, you get an answer (or patch) from Oracle pretty quickly. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 8:29 AM > Do you get any trace files for ora-600 ora-7445 or alike? Is it parallel > query? > Is the query iunusual in any shape or form? What about 9.2.0.4? > > -- > Mladen Gogala > Oracle DBA > > > > -----Original Message----- > [EMAIL PROTECTED] > Sent: Monday, September 08, 2003 3:39 PM > To: Multiple recipients of list ORACLE-L > > > > Good day to everyone > > Oracle 9.2.0.3 returns different (wrong!) results when hash joins are > enabled. > > After (at session level) disabling hash joins, query returns correct > results. > The very same query, with exactly same data, returns valid values on 8.1.7 > database. > > Has someone else seen this? This may leed to disastrous logical corruption > of > database. > > Any input, explanation, patches, stories or workarround tips, beside > disabling > hash joins? > > Thanks, > Vladimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
