Re: Oracle Process Problem

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_at_gmail.com> 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
>

--
http://www.freelists.org/webpage/oracle-l