_optimizer_ignore_hint in oracle
Tutorials Shared by the Internet Community
_optimizer_ignore_hint in oracle_optimizer_ignore_hint hidden parameter in oracle
Total Hits - 1309
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.
Oracle 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.
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.http://dbaclass.com/article/_optimizer_ignore_hint/