Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: High CPU usage

Re: High CPU usage

From: joel garry <joel-garry_at_home.com>
Date: 11 Oct 2006 13:09:08 -0700
Message-ID: <1160597348.844631.216910@k70g2000cwa.googlegroups.com>

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
Received on Wed Oct 11 2006 - 15:09:08 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US