Re: disable adaptive plan in 19c

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 14 Sep 2022 17:52:02 +0100
Message-ID: <CAOVevU7SvYEUN44s3sZVOZe8eKjWeJem0t3OHUmr0aeCMy00XA_at_mail.gmail.com>



Hi Jeffrey,

Yes, of course:

SQL> _at_hint adaptive

NAME                           SQL_FEATURE                    CLASS
              VERSION  INVERSE                        TARGET_LEVEL
------------------------------ ------------------------------
--------------------------- -------- ------------------------------
----------------------------------------
ADAPTIVE_PLAN                  QKSFM_ADAPTIVE_PLAN            ADAPTIVE_PLAN
              12.1.0.2 NO_ADAPTIVE_PLAN               Statement
NO_ADAPTIVE_PLAN               QKSFM_ADAPTIVE_PLAN            ADAPTIVE_PLAN
              12.1.0.2 ADAPTIVE_PLAN                  Statement

This script: https://github.com/xtender/xt_scripts/blob/master/hint.sql

On Wed, Sep 14, 2022 at 5:43 PM Beckstrom, Jeffrey <jbeckstrom_at_gcrta.org> wrote:

> Is it possible to disable adaptive plans for a given sql statement with a
> hint in 19c?
>
>
>
> Jeffrey Beckstrom
>
> Greater Cleveland Regional Transit Authority
>
> 1240 W. 6th Street
>
> Cleveland, Ohio 44113
>
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 14 2022 - 18:52:02 CEST

Original text of this message