关闭smon清理:
SQL> oradebug setorapid
SQL> oradebug event 10513 trace name context forever, level 2
打开smon清理:
SQL> oradebug setorapid
SQL> oradebug event 10513 trace name context off
这么查:
select
pid, program from v$process where program like '%SMON%';
但是这个10513的 event 含义代表什么可以看 $ORACLE_HOME/rdbms/mesg/oraus.msg

参考:
How to Disable Parallel Transaction Recovery When Parallel Txn Recovery is Active (Doc ID 238507.1)
阅读(148) | 评论(0) | 转发(0) |