Re: Wrong Results - Bad Execution Plan
- From: "Henry Poras" <henry@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Nov 2007 09:42:54 -0500
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ian Cary
> Sent: Monday, November 19, 2007 5:28 AM
> To: henry@xxxxxxxxxxxxxxx
> Cc: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
> 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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
