Re: CPU is 0% idle- Performance issue in 10g database

From: 조동욱 <ukja.dion_at_gmail.com>
Date: Thu, 17 Apr 2008 09:52:04 +0900
Message-ID: <43c2e3d60804161752n67d058adtf809805aa7b31fa0@mail.gmail.com>


2008/4/17, Pratap Singh (c) <psingh_at_vmware.com>:
>
> 9i to 10g upgrade has some performance changes, enough to cause 100% cpu.
>
> Do not have link handy for upgrade Gotcha's.
>
>
>
> Thanks,
>
> PB Singh
>
>
>
> ------------------------------------------------------------
>
> PB Singh
>
> DW Architect and Sr Data Modeler
>
> VMware
>

Totally agreed.
Upgrading to 10g from 9i can be sometimes a total mess-up, because both are 2 different monsters.

Quick but dirty solution would be a total recall to previous version by setting

- optimizer_features_enable = [your previous version]
- unset new-feature optimizer parameter
- recollect statistics just as previous manner
- misc.

Google it for upgrade issue of 10g.

Dion Cho

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 16 2008 - 19:52:04 CDT

Original text of this message