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 >