Troubleshooting: Oracle 19c wait event ‘latch: MGA shared context root latch’

  • 2021/07/15
  • ORACLE [C]系列, ORACLE 9i-23c
  • 1,139 views
  • Troubleshooting: Oracle 19c wait event ‘latch: MGA shared context root latch’已关闭评论

最近一套客户环境从12C 升级19c(19.9)后在我们的监控上Wait class “Concurrency”等待告警进入TOP, 但是从V$SESSION和ASH view中的活动(active)的会话并未显示这么严重等待， AWR的top event中同样也不存在， 但是算在了Wait Classes by Total Wait Time和Background Wait Events里面，具体的wait event为“latch: MGA shared context root latch” , 1小时的AWR些latch wait 时间高达55,141秒，

,

阅读全文