_optimizer_ignore_hint in oracle

Synopsis

_optimizer_ignore_hint hidden parameter in oracle

Statistics

  • 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

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.\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.

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

Broken  |   Save  |   Liked  |   Down

Advertisements