Re: Oracle Process Problem

Hi Bala

What patch level are you on, someone will be asking it sooner or later? Have you tried analyzing your system with statspack, Do you have the dbconsole installed and running, perhaps browsing some of the performance graphs will give you some pointers as to where your cpu consumption is going.

Check if your console is running by typing on the command line emctl status dbconsole (apologies if you knew how).

For someone new or les experienced the console can be a good guide to learning. YOu can just become a point and click guy and some thigs are easier but, use to as a tool to learn how to do things at the command line.

Cheers

Peter

On Thu, 2007-12-13 at 15:50 +0530, 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

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