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

  • From: "조동욱" <ukja.dion@xxxxxxxxx>
  • To: psingh@xxxxxxxxxx
  • Date: Thu, 17 Apr 2008 09:52:04 +0900

2008/4/17, Pratap Singh (c) <psingh@xxxxxxxxxx>:
>
>  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

Other related posts: