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

Ann

   This is a wide topic to address in few emails. But, I would tell you a strategy I would use If I were you.

1. Snap couple of statspack report during peak times, understand where the bottleneck is.
2. Look at server performance metrics to see if there is any glaring issues or if the performance issues can be attributed to any thinkg.
3. If you understand business well, find what is slow, trace that process, tkprof and see where time is being spent.
4. Use other tools such as sesspack.. http://blog.tanelpoder.com/2007/06/24/session-level-statspack/
5. Since you are on 10.2, you may be able to use ASH.

 That would be a good starting point.

Thanks
Riyaj Shamsudeen
The Pythian Group: http://www.pythian.com/blogs/author/shamsudeen Personal: orainternals.wordpress.com
On Wed, Apr 16, 2008 at 7:52 PM, Á¶µ¿¿í <ukja.dion_at_gmail.com> wrote:

> 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