Re: disable histogram usage at session / statement level

Hi,
Have you checked that one:
/*+ opt_param('_optimizer_use_histograms' 'false') */

Best Regards

On Thu, Mar 18, 2021 at 2:16 PM Jonathan Lewis <jlewisoracle_at_gmail.com> wrote:

>
> Adding the hint
>
> /*+ opt_param('_fix_control','9550277:1') */
>
> seems to work.
>
> Regards
> Jonathan Lewis
>
>
>
>
> On Thu, 18 Mar 2021 at 09:49, Laurentiu Oprea <laurentiu.oprea06_at_gmail.com>
> wrote:
>
>> Hello,
>>
>> Is there a method to influence the optimizer at session / statement level
>> to avoid histogram (especially hybrid) usage?
>>
>> Thank you.
>>
>

-- 
*Chinar Aliyev*


Visit My         :Blog <http://chinaraliyev.wordpress.com/>
Let's Connect -
<http://fr.linkedin.com/pub/mohamed-houri/11/329/857/>*Linkedin
Profile <https://www.linkedin.com/in/chinaraliyev/>*

My Twitter <https://twitter.com/MohamedHouri>      - ChinarAliyev
<https://twitter.com/ChinarAliyev>

--
http://www.freelists.org/webpage/oracle-l