Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Wrong Results - Bad Execution Plan

Re: Wrong Results - Bad Execution Plan

From: Henry Poras <henry_at_itasoftware.com>
Date: Mon, 19 Nov 2007 09:42:54 -0500
Message-ID: <000501c82aba$782fa090$8f00040a@itasoftware.com>


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
Received on Mon Nov 19 2007 - 08:42:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US