-
cpu intensive process
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
-
join v$session,v$process,v$sqlarea. yo'll get what you want.
Akash
OCP 8i
-
Or simply use awr report.
-
where do I get the awk report?
-
awr not awk, its a 10g report - seeing as though you dont say what version you are on you get limited help
-
is this similar to statspack?
-
oh yeah it's kind of upgraded statspack report.
Akash
OCP 8i
-
Mahendra -DBA
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
-
Originally Posted by 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
so just kill it without working out what it is doing - interesting
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|