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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle Process Problem

Re: Oracle Process Problem

From: Andrew Kerber <andrew.kerber_at_gmail.com>
Date: Thu, 13 Dec 2007 09:56:32 -0600
Message-ID: <ad3aa4c90712130756h46baa1ecjd511eb6fde0bbdf5@mail.gmail.com>


Just looking at the configuration (4 cpus, 1G of ram), It is very possible the source of your problem is insufficient memory. 4g should be the absolute minimum for a 4 cpu system, 8 is better. It might be interesting to see how much time your machine is spending swapping processes out.

On Dec 13, 2007 9:50 AM, Hemant K Chitale <hkchital_at_singnet.com.sg> wrote:

>
>
> 100% CPU for processes could be either of
> a. They are "runaway" processes -- the client has abnormally exited.
> Get the client process and machine name and program from v$session
> and verify if the client is still alive. (to go from the Unix PID to the
> Oracle SID in V$session , use
> select s.sid, s.serial#, s.machine, s.program, s.process from
> v$session s, v$process p
> where s.paddr=p.addr and p.spid='&unix_pid'; )
>
> b. They are doing a lot of logical I/O. Query v$sessstat for
> "consistent gets"
> and "CPU used by this session" at quick intervals and see if these
> are consistently
> incrementing. In that case, you need to validate the SQL that these
> sessions are
> running -- wrongly used indexes / nested loops etc can manifest as 100%
> cpu
> if all the blocks are already in the buffer cache, in which case
> v$session_wait
> will not show any active wait for these sessions.
>
> c. They are repeatedly spinning on latches . However, you seem to
> have checked this
> out (use v$session_wait at quick intervals or v$session_event to see
> if these sessions
> are incrementing latch wait counts and wait times).
>
> Hemant
> At 06:20 PM Thursday, Anju Bala wrote:
> >hi list,
> >
> >We are running Oracle 9iR2 on Linux ES4. there are certain oracle
> >process which is consuming almost 100% of the cpu. I tried finding
> >if there is any latch issue but could not find any specific problem
> >though I am not very good DBA but I tried all the possibilities I
> >could. Could anyone please let me how to figure this problem out and
> >resolve it??
> >
> >System config : 4 CPU with 1GB RAM
> >
> >TIA
> >
> >Bala
>
>
> Hemant K Chitale
> http://hemantoracledba.blogspot.com
>
> "There is more to life than increasing its speed."
> Mohandas Gandhi Quotes
> : http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Dec 13 2007 - 09:56:32 CST

Original text of this message

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