Re: Oracle Process Problem

  • From: "Rajeev Prabhakar" <rprabha01@xxxxxxxxx>
  • To: oraclebala@xxxxxxxxx
  • Date: Thu, 13 Dec 2007 06:19:17 -0500

Hello Bala

1) Try running the awr script. Look at the output, it should give you some
     pointers.
2) Are these end-user processes OR background processes ? Please
     clarify.
3) Did you check in metalink for any relevant bugs ?

Rajeev

On Dec 13, 2007 5:20 AM, Anju Bala <oraclebala@xxxxxxxxx> 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
>

Other related posts: