latch row cache objects 等待事件说明

最新推荐文章于 2025-01-02 19:07:55 发布

最新推荐文章于 2025-01-02 19:07:55 发布 · 188 阅读

文章标签：

#数据库

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.youkuaiyun.com/xujinyang/article/details/6858059

Oracle HANGANALYZE功能诊断DB hanging

http://blog.youkuaiyun.com/xujinyang/article/details/6858086

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