Re: High CPU usage

shiva wrote:
> We recently migrated from Oracle 9.2.0.1(Solaris 9) standalone to 2
> node Oracle 10.2.0.2 RAC(solaris 9). Previously database used to run on
> 4*900MHZ CPUs and now it runs on 2*4*1.2GHZ CPUs. After this migration
> cpu usage on both nodes are very high. In the range of 70-80%.
> (Beforein 9i it used to be less then 20%). The thing which bothers me
> is out of that 70% CPU usage, oracle is using about 40% and Kernel is
> using about 30%. I bumped SGA and PGA on both nodes and usage is still
> same. Any pointers on what to look would be appreciated.
>
> Thanks

How's your MMON process look?

jg

--
@home.com is bogus.
Datacenters, doomed as doomed can be.
http://blogs.sun.com/jonathan/entry/computing_in_the_strangest_places