首先将引起cpu过高的几个进程ID进行查询
会发现PID为22447,21826,21535,22636,22785,21148的进程占用CPU过高
然后要用sys的账号登陆Oracle
SELECT *
FROM V$SQL
WHERE SQL_ID IN
(SELECT PREV_SQL_ID
FROM V$SESSION
WHERE PADDR IN
(SELECT ADDR
FROM V$PROCESS
WHERE SPID IN (22447, 21826, 21535, 22636, 22785, 21148)));
最终指向两条SQL语句,需要修改优化。