TOP
查询高CPU
Swap: 40957708k total, 223280k used, 40734428k free, 49790260k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
13942 oraprod 25 0 25.5g 7.3g 7.0g R 100.1 11.7 29:05.26 oracle
---查询SID
select s.sid,s.username,s.event,s.wait_time,s.state,s.seconds_in_wait,p.PROGRAM,s.MACHINE
from v$session s,v$process p
where p.spid=13942 and s.PADDR=p.ADDR ; --1118
---根据SID查询sql
SELECT SQL_TEXT
FROM V$SQLAREA A, V$SESSION B
WHERE A.SQL_ID = B.PREV_SQL_ID
AND B.SID = 1118;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15187685/viewspace-759248/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15187685/viewspace-759248/