Re: Anyone run across Bug 6503543 Suboptimal plan due to bad cardinality estimate for RANGE join predicates

From: Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com>
Date: Tue, 17 Feb 2009 08:36:33 -0600
Message-ID: <203315c10902170636g647389a1waad6c0c3530ea56b_at_mail.gmail.com>

Charles
  Looking at 10053 lines you have posted in your blog, I think that, predicates are not applied in correct place. I am not sure though.

  Can you please send me output of the explain plan output? Specifically, I am looking for access_predicates and filter_predicates printed at the end of explain plan. Also, can you please send me 10053 trace files too ?

set lines 120 pages 100
explain plan <your query>;
select * from table(dbms_xplan.display);

-- 
Cheers

Riyaj Shamsudeen
Principal DBA,
Ora!nternals -  http://www.orainternals.com
Specialists in Performance, Recovery and EBS11i
Blog: http://orainternals.wordpress.com


On Tue, Feb 17, 2009 at 8:11 AM, Charles Schultz <sacrophyte_at_gmail.com>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.


--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 17 2009 - 08:36:33 CST