Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 32651 invoked from network); 13 Dec 2007 06:16:50 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 13 Dec 2007 06:16:49 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DE9087D7BA9; Thu, 13 Dec 2007 07:16:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 26448-01; Thu, 13 Dec 2007 07:16:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 516247D7734; Thu, 13 Dec 2007 07:16:49 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 13 Dec 2007 06:29:24 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3F3C97D84F5 for ; Thu, 13 Dec 2007 06:29:24 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16934-01 for ; Thu, 13 Dec 2007 06:29:24 -0500 (EST) Received: from mail14.syd.optusnet.com.au (mail14.syd.optusnet.com.au [211.29.132.195]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9E2127D81A6 for ; Thu, 13 Dec 2007 06:29:23 -0500 (EST) Received: from [192.168.2.5] (d58-109-9-244.dsl.nsw.optusnet.com.au [58.109.9.244]) by mail14.syd.optusnet.com.au (8.13.1/8.13.1) with ESMTP id lBDBSvNC029063; Thu, 13 Dec 2007 22:29:09 +1100 Subject: Re: Oracle Process Problem From: Peter McLarty To: oraclebala@gmail.com Cc: oracle-l@freelists.org In-Reply-To: <887a5be30712130220u7eea8513k5fa5aa20007c61b2@mail.gmail.com> References: <887a5be30712130220u7eea8513k5fa5aa20007c61b2@mail.gmail.com> Content-Type: multipart/alternative; boundary="=-n9wbT1kl0HG5IckRaP+G" Organization: Pacific DBMS Pty Ltd Date: Thu, 13 Dec 2007 21:28:38 +1000 Message-Id: <1197545318.25989.7.camel@notebook5.pacificdbms.com.au> Mime-Version: 1.0 X-archive-position: 3912 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: peter.mclarty@pacificdbms.com.au Precedence: normal Reply-to: peter.mclarty@pacificdbms.com.au List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --=-n9wbT1kl0HG5IckRaP+G Content-Type: text/plain Content-Transfer-Encoding: 7bit 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 --=-n9wbT1kl0HG5IckRaP+G Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 7bit 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
--=-n9wbT1kl0HG5IckRaP+G-- -- http://www.freelists.org/webpage/oracle-l