Search This Blog

Thursday, May 19, 2011

OPTIMIZER_GOAL is obsolete


SQL> alter session set optimizer_goal=rule;
alter session set optimizer_goal=3rule
                                *
ERROR at line 1:
ORA-01986: OPTIMIZER_GOAL is obsolete
However, you can still use the optimizer_mode at the session level:
SQL>  alter session set optimizer_mode=rule;

Session altered.

No comments:

Post a Comment