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/tianlesoftware/archive/2011/06/04/6525628.aspx
Oracle HANGANALYZE 功能诊断 DB hanging
http://blog.csdn.net/tianlesoftware/archive/2011/04/13/6321961.aspx
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
DBA6 群:158654907 聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请