latch row cache objects 等待事件 说明

Row Cache Objects:

       The row cache objects latch contention usually means there is contention in the data dictionary. This problem may also be a symptom of excessive parsing of SQL statements that depend on public synonyms. Increasing the shared pool usually solves this latch problem.

       You usually increase the shared pool for a library cache latch problem well before this one is a problem.

 

       根据上面的这段蚊子说明， 增大shared pool 通常可以解决这种latch 问题。 不过具体情况还是需要具体对待，可以做HANGANALYZE和SYSTEM STATE DUMP来帮助定位为题。 参考：

      

       Oracle oradebug 命令 使用说明

       http://blog.csdn.net/xujinyang/article/details/6858059

 

       Oracle HANGANALYZE 功能诊断 DB hanging

       http://blog.csdn.net/xujinyang/article/details/6858086

 

 

 

 

 

-------------------------------------------------------------------------------------------------------