Re: Baseline usage?

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Fri, 26 Sep 2014 12:57:31 -0500
Message-Id: <2E39A792-622C-4364-9C62-33DC4162FE1B_at_gmail.com>

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

>

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

Received on Fri Sep 26 2014 - 19:57:31 CEST