Re: Wrong Results - Bad Execution Plan
- From: "Ian Cary" <Ian.Cary@xxxxxxxxxxxxxx>
- To: henry@xxxxxxxxxxxxxxx
- Date: Mon, 19 Nov 2007 10:28:22 +0000
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
