Re: disable histogram usage at session / statement level
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Thu, 18 Mar 2021 10:15:53 +0000
Message-ID: <CAGtsp8=CZYfvT=JUo=v99gjyNndCMYW3UuxCc2fVnXAw4Z6OUw_at_mail.gmail.com>
Date: Thu, 18 Mar 2021 10:15:53 +0000
Message-ID: <CAGtsp8=CZYfvT=JUo=v99gjyNndCMYW3UuxCc2fVnXAw4Z6OUw_at_mail.gmail.com>
Adding the hint
/*+ opt_param('_fix_control','9550277:1') */
seems to work.
Regards
On Thu, 18 Mar 2021 at 09:49, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
wrote:
> Hello,
Jonathan Lewis
>
> Is there a method to influence the optimizer at session / statement level
> to avoid histogram (especially hybrid) usage?
>
> Thank you.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 18 2021 - 11:15:53 CET