cpu运行100%,进程中大部分都是oracle的！需要重起系统吗？！

CNL

查一下当前数据库在用什么SQL语句:

1. 
   
2. SELECT osuser, username, sql_text from v$session a, v$sqltext b
   
3.     where a.sql_address =b.address order by address, piece;
   

复制代码

再查一下那个session用的 CPU最多

1. 
   
2. select a.sid,spid,status,substr(a.program,1,40) prog,a.terminal,osuser,value/60/100 value
   
3.     from v$session a,v$process b,v$sesstat c
   
4.     where c.statistic#=12 and c.sid=a.sid and a.paddr=b.addr order by value desc;
   

复制代码

然后优化你的SQL语句