Re: Cost Based Optimizer

As well as the variables mentioned by everybody else, I believe that
in 9.2(and presumably higher) setting CURSOR_SHARING=SIMILAR can cause
the
statement to have multiple execution plans as well. 
-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

--
http://www.freelists.org/webpage/oracle-l

Other related posts: