RE: Query returns wrong results

  • From: "Schultz, Charles" <sac@xxxxxxxxxxxxx>
  • To: <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jun 2006 09:00:36 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ian Cary (C)
Sent: Wednesday, June 21, 2006 4:04 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Query returns wrong results

A few weeks ago I posted a 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


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







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

Thank you for your cooperation.

Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000

Other related posts: