_optimizer_ignore_hint in oracle

Tutorials Shared by the Internet Community

Advertisements


_optimizer_ignore_hint in oracle

_optimizer_ignore_hint hidden parameter in oracle

Statistics

  • 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

Description

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.

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.

http://dbaclass.com/article/_optimizer_ignore_hint/

Broken  |   Save  |   Liked  |   Down

Advertisements