Re: Wrong Results - Bad Execution Plan

Ian,

I don't think this is the same bug. My problem is from faulty ordering in the execution plan which doesn't seem related to "prefetch".

Henry

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ian Cary
> Sent: Monday, November 19, 2007 5:28 AM
> To: henry_at_itasoftware.com
> Cc: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
> Subject: Re: Wrong Results - Bad Execution Plan
>
>
>
> I had something similar on 10.2.0.2 where a query returned
> the wrong set of
> results. It was a known bug with pretech and can be worked around by
> setting the following hidden parameters.
>
> _table_lookup_prefetch_size=0
> _table_lookup_prefetch_thresh=<a large number> 20000000
> worked for me
>
> If you need any further a Metalink lookup with a search string of
> "prefetch" (knowing what to look for helps :) ) gives quite a few
> references to queries returning wrong results.
>
> Cheers,
>
> Ian
>

--
http://www.freelists.org/webpage/oracle-l