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>
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-lReceived on Wed Sep 14 2022 - 18:52:02 CEST