impact of changing optimizer_features_enable

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 23 Jun 2007 11:10:07 +0700

all,

i have a funny things about how oracle given execution plan.

now my db is 10.2.0.3 on itanium 64bit.
when tried *.optimizer_features_enable from 10.2 until 9.2 , the
report was not much different (so slow). but when change to
*.optimizer_features_enable=8.1.7, it amazingly so so so fast....

so, does anyone have experiences about changing the above parameter
and the impact to the applications?

thanks for your sharing...

--
regards
ujang
--
//www.freelists.org/webpage/oracle-l


Other related posts: