oracle 10g migration due to performance problems

Hi,

The company we work for is currently trying to push down the CPU consumption of an application which runs under Oracle 8.1.7. Among other ways (optimizing, finding and rewriting the resource hungry parts), one possible option is to migrate to 10g. Some say that the upgrade in itself (not optimizing anything, except possible plans going mad or getting sources to compile) will help in this matter. Others have doubts or different opinions. Currently we are in the middle of setting up a test environment to measure things but I would be very interested in your opinion/experience beforehand. Do you think migrating to 10g helps in reducing resource consumption?

Regards,

Krisztian Received on Tue Jan 30 2007 - 16:58:59 CST