cursor: mutex S等待事件

cursor: mutex * events等待事件 cursor: mutex * events等待事件用於Cursor Parent 和 Cursor stats型別的操作： ‘Cursor: Mutex S’ ， 某個程式以SHRD S mode申請一個Mutex， 而該Mutex要麼被其他程式已EXCL X mode所持有，要麼其他程式正在更新mutex 上的Ref Count。

• 相關型別的操作一般是檢測父遊標或者CURSOR統計資訊資料， 此外查詢V$SQLSTATS也會造成CURSOR statistics被查詢

詳見 《深入理解Oracle中的Mutex》一文     A session waits on this event when it is requesting a mutex in shared mode, when another session is currently holding a this mutex in exclusive mode on the same cursor object. Solutions Solutions for mutex wait problems are very similar to each other. See Analysis of Waits on Mutexes for more information and troubleshooting ideas.

本文轉自maclean_007 51CTO部落格，原文連結:http://blog.51cto.com/maclean/1277901