Hi,
We have several databases (E-bus and non-E-bus) which are being upgraded to 10g. One common thing we are seeing everywhere is performance issues after upgrade (even with larger new servers for 10g instances) and changes in explain plan. While this may be common but it becomes a problem when alter table commands also start taking longer as part of an upgrade. The difference is significant. Opening a tar with Oracle is of no use as they say to upgrade to a next level. Now we have upgraded all instances to Oracle recommended 10.2.0.3. One thing is that the performance issue goes away as soon as we set optimizer_features_enable to 9.2.0. Not sure if we can keep recommending this solution every time.
Please let me know if anyone has faced these issues and what they have done about it. The issue spans across various platforms (Linux, Solaris) and Applications (E-Bus, Peoplesoft, Kronos, Homegrown apps)

Thanks,
Sandeep