- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
New session level hidden parameter to NOT IGNORE failed hints.
A lot of DBA's comes to a situation where we put some hints in a query but we do some typo or semantic conflict/error.
So, instead of showing an error, oracle wisely executes the query ignoring the hints. I'm OK with that.
The problem is that in many situations we DO want to know that Oracle is not obeying our hints! Why not give us a way to know that, maybe throwing an error?
Maybe Oracle could create a session level hidden parameter "_optimizer_disallow_failed_hints" that default to FALSE, but if we set it to TRUE in one session, the query would fail because the hints are invalid.
Thus, we could easily track and check that we made some mistake.
alter session set _optimizer_disallow_failed_hints=true;
select /*+ PARALLEL (x,20) */ *
from scott.emp t;
ORA-09876 - Your hint is invalid.