cpu intensive process

[reeshe]

Hi,

I issue a TOP command in my Linux DB and I see this process which eats
all the CPU (100%), How do I find this inside the database which program is being run?

PID USER PR NI %CPU TIME+ %MEM VIRT RES SHR S COMMAND
9763 oracle 25 0 100 7:35.75 3.6 1121m 146m 142m R oracle


Thanks

[akas_chauhan]

join v$session,v$process,v$sqlarea. yo'll get what you want.

[tamilselvan]

Or simply use awr report.

[reeshe]

where do I get the awk report?

[davey23uk]

awr not awk, its a 10g report - seeing as though you dont say what version you are on you get limited help

[reeshe]

is this similar to statspack?

[akas_chauhan]

oh yeah it's kind of upgraded statspack report.

[mahendra_mmm]

use this command

v$session,v$process in which you use sid,addr,pid,saddr,osuser,status

if status is inactive then kill this process pid. by this

OS level

$kill -9 pid

[davey23uk]

use this command

v$session,v$process in which you use sid,addr,pid,saddr,osuser,status

if status is inactive then kill this process pid. by this

OS level

$kill -9 pid

so just kill it without working out what it is doing - interesting