@H_301_1@
@H_301_1@
会发现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)));