ORA-32701 error in alert.log M000 hang event ‘not in wait’ during flush AWR

  • 2016/06/20
  • ORACLE 9i-23ai
  • 2,706 views
  • ORA-32701 error in alert.log M000 hang event ‘not in wait’ during flush AWR已关闭评论

环境是一套11.2.0.3 2nodes RAC on hpux-ia31, alert中出现ora-32701 hangmgr错误， 从trace文件中发现是m000进程是mmon的辅助进程，用于flush AWR相关数据，有一个wait event: enq: WF – contention, 这也是flush AWR数据时相关的enqueue等待，但是blocker进程是not in wait

, ,

阅读全文