Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: April 28, 2017 - 8:37 pm UTC

Last updated: April 29, 2017 - 1:48 am UTC

Version: 11.2.04

Viewed 1000+ times

You Asked

Hi All,
We observed a sudden increase in CPU usage in one of the Exa node on 10th April and it is still same till date. Example CPU utilization increased from 2% to 66 % and same till today.

Can someone help me how to find what exactly caused this sudden CPU increase.

and Connor said...

Start with 'top' or similar. Locate the processes that are using the most CPU. If they are Oracle processes, you can locate the sessions with a query like

select s.sid, s.serial#, s.USERNAME, s.module, s.sql_id, s.program
from v$session s, v$process p
where s.PADDR = p.ADDR
and   p.SPID = :process


Once you have session(s), then you can use tracing, SQL Monitor, AWR, ASH etc to drill down into what they are doing.

If they are not Oracle processes...then you'd need to investigate elsewhere.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Query

Karthik, May 03, 2017 - 10:06 am UTC

get the process id from top command at unix/linux

pass the process id in the below sql:

SELECT s.client_identifier,s.action,s.status,s.module,s.osuser,s.machine,s.terminal,s.program, s.* FROM v$session s, v$process v WHERE v.addr=s.paddr AND v.spid=&spid;

Thanks
Karthik Rao

More to Explore

Performance

Get all the information about database performance in the Database Performance guide.