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
statement to have multiple execution plans as well. 
Niall Litchfield
Oracle DBA


Other related posts: