Tag Archives: latch free

10.2出现SQL Memory Manager latch类型的latch free

客户环境出现了明显的LATCH FREE等待事件,而等待的latch类型为sql memory manager latch。 详细版本为10.2.0.5 RAC for Hp-ux,问题出现时,AWR的TOP 5信息为: Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class latch free 387,948 1,686,005 4,346 60.8 Other CPU time 219,941 7.9 gc buffer busy 19,927,407 8,938 0 .3 Cluster … Continue reading

Posted in ORACLE | Tagged , | Leave a comment