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@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.