Re: High CPU usage
- From: Hananto Wicaksono <hananto.wicaksono@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Wed, 12 May 2010 10:53:08 +0800
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:
