prunoki wrote:
> 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
The upgrade will likely help to some extent. That extent being related
to how good or bad your code and schemas are. Certainly getting rid of
8.1.7 and moving to more efficient table, index, and SQL syntax will
make a far bigger difference.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Tue Jan 30 2007 - 18:13:42 CST
