all session have the optimazer goal CHOOSE, but i want set optimizer goal RULE, how can i do it?
Printable View
all session have the optimazer goal CHOOSE, but i want set optimizer goal RULE, how can i do it?
alter session set optimizer_goal=rule
See ( http://technet.oracle.com/docs/produ...18.htm#2053036 ) for other options.
how can change the optimazer goal in other session?