| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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
For the latest data on the economy and society consult National Statistics at http://www.statistics.gov.uk
Please Note: Incoming and outgoing email messages are routinely monitored for compliance with our policy on the use of electronic communications
Legal Disclaimer : Any views expressed by the sender of this message are not necessarily those of the Office for National Statistics
The original of this email was scanned for viruses by the Government Secure Intranet Anti-Virus service supplied by Cable&Wireless in partnership with MessageLabs. (CCTM Certificate Number 2006/04/0007.) On leaving the GSi this email was certified virus free. Communications via the GSi may be automatically logged, monitored and/or recorded for legal purposes.
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 19 2007 - 04:28:22 CST
 |
 |