Re: oracle 10g migration due to performance problems

"prunoki" <hegyvari_at_ardents.hu> wrote in news:1170197939.588797.119770 @q2g2000cwa.googlegroups.com:

> 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
>

Oracle10g expands greatly on the managability of the databases. There is overhead associated with this. The optimizer has much more smarts, but it comes with heavier CPU cost to build a PLAN. I helped make a benchmark for a high-profile application moving from Oracle8i to Oracle9i. There was one surprise query, but the rest did not change. There was a slight increase in execution time because of the extra overhead of the optimizer.

I think that you will only see improvements if you modify your application to take advantage of new features in Oracle10g.

Andy Young Received on Wed Jan 31 2007 - 18:11:44 CST