_optimizer_ignore_hint in oracle


_optimizer_ignore_hint hidden parameter in oracle


  • Total Hits - 1403

  • Total Votes - 0 votes

  • Vote Up - 0 votes

  • Vote Down - 0 votes

  • Domain - dbaclass.com

  • Category - Oracle/DBA Concepts

  • Submitted By - rajkishore

  • Submitted on - 2017-11-19 20:28:18


Sometimes application queries come with the specific hint, which may impact your database performance. And it is difficult to find and remove these hints from each query.\r\n\r\nOracle provided an undocumented hidden parameter, _optimizer_ignore_hint. If this parameter is set to true, Then it will ignore the hints mentioned in the SQL queries.

Source Website

Please use the following link to visit the site. There is a possibility that this content has been removed from the given URL or may be this site has been shut down completely.


Broken  |   Save  |   Liked  |   Down