参考:
https://www.cnblogs.com/xidabei/p/7884471.html
https://blog.csdn.net/azhou46/article/details/78922851
https://www.2cto.com/database/201302/187360.html
https://www.cnblogs.com/lidj/p/7125496.html
https://www.cnblogs.com/andy6/p/5926511.html
两个节点,有一台cpu100%了,另外一台没有
后面啥也没处理,下午就好了,推测可能还是 sga_max_size 设置问题。
猜测:当业务量比较大的时候,内存占用满了,就变成用磁盘了,就变得缓慢。
尝试调大sga_max_size
select s.sid,s.serial#, s.event, s.wait_time, w.seq#, q.sql_text
from v$session_wait w, v$session s, v$process p, v$sqlarea q
where s.paddr=p.addr and
s.sid=33 and
s.sql_address=q.address;
alter system kill session '738,1429';
SELECT SE.SID,
OPNAME,
TRUNC(SOFAR / TOTALWORK * 100, 2) || '%' AS PCT_WORK,
ELAPSED_SECONDS ELAPSED,
ROUND(ELAPSED_SECONDS * (TOTALWORK - SOFAR) / SOFAR) REMAIN_TIME,
SQL_TEXT
FROM V$SESSION_LONGOPS SL, V$SQLAREA SA, V$SESSION SE
WHERE SL.SQL_HASH_VALUE = SA.HASH_VALUE
AND SL.SID = SE.SID
AND SOFAR != TOTALWORK