今天遇到一个SMON占用了一个CPU去做tansaction recovery :
分析 :
目前该JOB异常终止,导致回滚异常,SMON进程cost 100%cpu,因为该库设置了10351event ,目前通过禁用10351event 解决
SQL> select pid, program from v$process where program like '%SMON%';
PID PROGRAM
---------- ------------------------------------------------
6 oracle@stsun7 (SMON)
-- Disable SMON transaction cleanup:
SQL> oradebug setorapid <SMON's Oracle PID>
SQL> oradebug event 10513 trace name context forever, level 2
-- To enable the transaction recovery again:
SQL> oradebug setorapid <SMON's Oracle PID>
SQL> oradebug event 10513 trace name context off
---------------------------------------------------------------------------------------------------------------------参考文档:
Database Hangs Because SMON Is Taking 100% CPU Doing Transaction Recovery (Doc ID 414242.1) To BottomTo Bottom
In this Document
Goal
Solution
References
APPLIES TO:
Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.2.0.3 [Release 8.1.7