Re: High CPU usage
- From: seekuel <sandeil_tenebro@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 12 May 2010 11:09:24 +0800 (SGT)
Hi Hananto,
Thank you for the tip. Can you give some tips on identifying runaway forms? In
OS level I used top -u <databse or application user> where in I can see details
on the time the process is running and the cpu process it use. Is there another
way?
Regards,
Sandeil
--- On Tue, 5/11/10, Hananto Wicaksono <hananto.wicaksono@xxxxxxxxx> wrote:
From: Hananto Wicaksono <hananto.wicaksono@xxxxxxxxx>
Subject: Re: High CPU usage
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Tuesday, May 11, 2010, 7:53 PM
Hi,
On database level, if you are using 10g or above, generate AWR report and
analyze from there.
On application tier, try to find any runaway forms processes and terminate them
should you find any.
Hopefuly you'll get something.
Thanks.
Regards,
Hananto
On Wed, May 12, 2010 at 10:42 AM, seekuel <sandeil_tenebro@xxxxxxxxx> wrote:
Hello group,
We are experiencing a high cpu usage on our instance wherein it is a single
node with datafiles located remotely via NAS.
Here is our server system specifications:
CPU = Intel(R) Xeon(R) CPU E5420 @ 2.50GHz X4
MEMORY = 8 BG
I observed that the instance is not taking much of memory but all cpu reached
100% and this becomes a headache because our instance are very slow at this
point. I used the query "select COUNT(DISTINCT USER_ID) from ICX_SESSIONS where
LAST_CONNECT > SYSDATE - 1/24 and USER_ID != '-1';" and it shows 36. At this
point I will try to kill the processes that have its time 1hr or more and cpu
usage that is greater than 70% in OS level. I don't feel comfortable doing this
but it temporarily solve the issue.
Is there a cpu per user count per report generation guide on this? Your
suggestions are greatly appreciated.
Thank you,
Sandeil
Other related posts:
