Re: Baseline usage?

From: Mohamed Houri <mohamed.houri_at_gmail.com>
Date: Fri, 26 Sep 2014 20:49:41 +0200
Message-ID: <CAJu8R6iROKL=Pb5=vHfeOvsugqaC+Yy2tws2+fLzcX_Z+34e4Q_at_mail.gmail.com>

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_at_gmail.com>:

> 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_at_gmail.com>
> 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_at_gmail.com>
>> 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_at_gmail.com>
>> wrote:
>>
>>> Does anyone know where we can check and see how often a sql plan
>>> baseline is used?
>>>
>>> Sent from my iPad--
>>> http://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>

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

Received on Fri Sep 26 2014 - 20:49:41 CEST