Re: Anyone run across Bug 6503543 Suboptimal plan due to bad cardinality estimate for RANGE join predicates
- From: Charles Schultz <sacrophyte@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 18 Feb 2009 09:05:51 -0600
Update
I was unable to reproduce this issue in 10.2.0.4. Ironically, even though
the bug is for RANGE predicates, the query in question is using an EQUALITY
predicate. So I have to assume we are hitting some bug that is giving us an
ultra low selectivity (incorrectly) under specific situations in 10.2.0.3,
but no longer in 10.2.0.4.
On Tue, Feb 17, 2009 at 8:11 AM, Charles Schultz <sacrophyte@xxxxxxxxx>wrote:
> Good day, list,
>
> I was doing some tuning on a VPD view (a view that calls tables with FGAC
> policies) and the 10053 trace exhibited a gigantic index selectivity that
> surprised me. Curious if anyone else had run across this. I usually check
> out Jonathan Lewis's ScratchPad and look for notes from Richard Foote,
> Alberto Dell'Era, Greg Rahn and many others, but so far I have not seen that
> anyone hit this (of course, I was using google, so....). I am using a
> 10.2.0.3 database, for which the bug is specifically filed, supposedly fixed
> in 11.1.0.7.
>
> For those that like more information:
>
> http://orajourn.blogspot.com/2009/02/tuning-performance-example-using-10046.html
>
> --
> Charles Schultz
> Sent from: Champaign Illinois United States.
--
Charles Schultz
Sent from: Champaign Illinois United States.
Other related posts:
