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: Query returns wrong results

RE: Query returns wrong results

From: Schultz, Charles <sac_at_uillinois.edu>
Date: Wed, 21 Jun 2006 09:00:36 -0500
Message-ID: <565F609E6D736D439837F1A1A797F3419D0E51@ADMINMAIL1.ui.uillinois.edu>


Thanks. As with all great undocumented parameters (sarcasm), there is not much info on this. What units is the threshold in? And what else does it affect?


From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ian Cary (C) Sent: Wednesday, June 21, 2006 4:04 AM
To: oracle-l_at_freelists.org
Subject: Query returns wrong results

A few weeks ago I posted a 10.2.0.2 query example that produced the wrong results.  

This turned out to be a bug 5228983 and is related to partitioned tables so I thought I might as well post a warning.

The "fix" is  

"Workaround:
  Set "_table_lookup_prefetch_thresh" to a very high   value such that it disables prefetch."    

Cheers,  

Ian

.

This email is only intended for the person to whom it is addressed and may contain confidential information. If you have received this email in error, please notify the sender and delete this email which must not be copied, distributed or disclosed to any other person.

Unless stated otherwise, the contents of this email are personal to the writer and do not represent the official view of Ordnance Survey. Nor can any contract be formed on Ordnance Survey's behalf via email. We reserve the right to monitor emails and attachments without prior notice.

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jun 21 2006 - 09:00:36 CDT

Original text of this message

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