Re: Spd 19c adaptive statistics
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 5 Jan 2021 19:05:18 -0500
Message-ID: <469ecd9c-a665-370e-3fd6-75da796e77b1_at_gmail.com>
Date: Tue, 5 Jan 2021 19:05:18 -0500
Message-ID: <469ecd9c-a665-370e-3fd6-75da796e77b1_at_gmail.com>
Tim Hall to the rescue:
https://oracle-base.com/articles/12c/sql-plan-directives-12cr1
There is also a good article in DBA hell:
http://dbaparadise.com/2018/03/what-are-sql-plan-directives/
And my favorite is Lodovico Caldera:
http://www.ludovicocaldara.net/dba/sql-plan-directives-problem/
Finally, there is a little known and infrequently visited site at https://support.oracle.com:
How to Identify Specific SQL Plan Directives In Use For A SQL Statement (Doc ID 2390551.1)
Happy New Year
On 1/5/21 6:32 PM, Moustafa Ahmed wrote:
>
> I know I can tell from dbms_xplan cutsor note section but is there a
> bulk way to check history on dba_hist_xxx views to expose the note
> section and see if it was ever used?
>
-- Mladen Gogala Database Consultant http://mgogala.byethost5.com -- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 06 2021 - 01:05:18 CET