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 |