Re: Cost Based Optimizer

  • From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
  • To: tbarne@xxxxxxxxxxxxxxxxxxxxxxxxxx
  • Date: Fri, 20 May 2005 09:08:16 +0100

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: