How to Disable Hints Globally in an Application

In some cases you might want to disable hints globally from application but the application is difficult to change. You can use "_optimizer_ignore_hints" parameter to disable the hint in system level or session level.

Disable Hint in system level:

SQL> alter system set "_optimizer_ignore_hints"=true scope=both;

 

Disable hint in session level using Trigger:

SQL> Create or replace trigger ignore_hints_on_logon
after logon on database
begin
execute immediate 'alter session set "_optimizer_ignore_hints"= true';
end;
/


Comments