Optimacer Mode in another session

[marist89]

alter session set optimizer_goal=rule

See ( [url]http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/statem18.htm#2053036[/url] ) for other options.