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

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