Re: disable histogram usage at session / statement level

  • From: Jonathan Lewis <jlewisoracle@xxxxxxxxx>
  • To: "ORACLE-L (oracle-l@xxxxxxxxxxxxx)" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 18 Mar 2021 10:15:53 +0000

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@xxxxxxxxx>
wrote:

Hello,

Is there a method to influence the optimizer at session / statement level
to avoid histogram (especially hybrid) usage?

Thank you.

Other related posts: