Performance Tunning: cursor: mutex X & cursor: mutex S high wait after 12.2.0.1

  • 2017/08/12
  • Cloud, ORACLE 9i-23ai
  • 4,171 views
  • Performance Tunning: cursor: mutex X & cursor: mutex S high wait after 12.2.0.1已关闭评论

朋友一套12C R2多组户架构3节点RAC数据库反应数据库响应缓慢，因远程不方便，只拿到事后一份AWR，数据库出现较高的cursor: mutex X 和cursor: mutex S，sql verison能达到7000多，并且high version的SQL都是递归内部SQL, 12.2的隐藏参数_CURSOR_OBSOLETE_THRESHOLD原来现在默认已加大到了8192，

, , , , ,

阅读全文