Re: disable histogram usage at session / statement level

Here's an odd little detail from my library:

The fix_control isn't available in 10.2.0.5 but the hidden parameter is; then neither the parameter nor the fix_control are in 11.1.0.7 then the fix_control appears 1in 11.2.0.4.

Regards
Jonathan Lewis

On Thu, 18 Mar 2021 at 10:41, Chinar Aliyev <chinaraliyev_at_gmail.com> wrote:

> 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
>>
>>
>>

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