Re: Querying SQL Tuning Advisor

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 21 Sep 2017 11:10:54 +0100
Message-ID: <CABe10sZgaJGE_YC4=EChLm5zckCraYJj0jSdYYB7+gm+EKa5HA_at_mail.gmail.com>



You'll also find a bunch of useful examples at https://oracle-base.com/articles/10g/automatic-sql-tuning-10g (and associated 11g and 12c updates). I included the 10g one because it references the views.

On Wed, Sep 20, 2017 at 10:04 PM, Andy Klock <andy_at_oracledepot.com> wrote:

>
>
> On Wed, Sep 20, 2017 at 4:51 PM, Sheehan, Jeremy <JEREMY.SHEEHAN_at_fpl.com>
> wrote:
>>
>> Is anyone aware of a way to query SQL Tuning Advisor information? I’m
>> 99.9% sure this can be done, but I can’t figure out how. Has anyone done
>> this? Please let me know!
>>
>
> 11g: http://docs.oracle.com/cd/E28271_01/server.1111/e16638/
> sql_tune.htm#i35947
>
> 12c: http://docs.oracle.com/cd/B19306_01/server.102/
> b14211/sql_tune.htm#i35947
>
> Andy K
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 21 2017 - 12:10:54 CEST

Original text of this message