Instead of answering you, I prefere directing you to this interesting blog article of Dominic Brooks in which you might find a starting point to your path vers the correct answer http://orastory.wordpress.com/2014/02/05/awr-was-a-baselined-plan-used/ Best regards Mohamed Houri 2014-09-26 20:21 GMT+02:00 Seth Miller <sethmiller.sm@xxxxxxxxx>: > You can have multiple plans in the plan history per sql statement. You can > also have multiple baselines per sql statement. You can even have multiple > baseline plans enabled and accepted but none of these things means that > those plans will be used. > > Can you post examples of your findings? > > Seth Miller > > On Fri, Sep 26, 2014 at 12:57 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx> > wrote: > >> That's what I would have thought, but the AWR shows the queries, the >> timing on the AWR report indicates that the baseline was used, but the >> executions number never increases. >> >> Sent from my iPad >> >> On Sep 26, 2014, at 11:38 AM, Seth Miller <sethmiller.sm@xxxxxxxxx> >> wrote: >> >> If you mean number of executions, you can query >> DBA_SQL_PLAN_BASELINES.EXECUTIONS. >> >> Seth Miller >> >> On Fri, Sep 26, 2014 at 11:27 AM, Andrew Kerber <andrew.kerber@xxxxxxxxx> >> wrote: >> >>> Does anyone know where we can check and see how often a sql plan >>> baseline is used? >>> >>> Sent from my iPad-- >>> //www.freelists.org/webpage/oracle-l >>> >>> >>> >> > -- Houri Mohamed Oracle DBA-Developer-Performance & Tuning Member of Oraworld-team <http://www.oraworld-team.com/> Visit My - Blog <http://www.hourim.wordpress.com/> Let's Connect - <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin Profile <http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>* My Twitter <https://twitter.com/MohamedHouri> - MohamedHouri <https://twitter.com/MohamedHouri>