impact of changing optimizer_features_enable


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

now my db is 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...


Other related posts: