Plan not Chosen and ORA-00907 Raised With Execution Plan Derived from Hinted Form of Query, Loaded into SQL Plan Baseline of its Non-Hinted Counterpart
(Doc ID 2077682.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Information in this document applies to any platform.
- The instructions laid out in <Document 787692.1> to load the execution plan for the hinted form of a SQL statement into the SQL plan baseline of its non-hinted counterpart have been followed, but the desired execution plan is not chosen.
- A SQLT report on the query indicates an ORA-00907 error, "missing right parenthesis," even though the execution plan has been evolved and is both enabled and accepted:
- Executing the query against the SQL Tuning Advisor also returns the error ORA-00907.
- ASH report shows that the query has executed many times (122 in this case), albeit not with the execution plan desired:
Since the query executes, this means that there cannot be anything wrong with the syntax of the non-hinted form of the SQL statement.
Added the execution plan for the hinted form of the SQL statement into the SQL plan baseline of its non-hinted counterpart.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!