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;

/