Re: Oracle Process Problem
- From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- To: hkchital@xxxxxxxxxxxxxx
- Date: Thu, 13 Dec 2007 09:56:32 -0600
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@xxxxxxxxxxxxxx> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
