oracle ‘row cache objects’ 等待事件解释

教程发布:风哥 教程分类:ITPUX技术网 更新日期:2022-02-12 浏览学习:387

oracle 'row cache objects' 等待事件解释

The 'row cache objects' latch is called most frequently from 'kqrpre: find obj'. This module tries to find details of an object being parsed in the row cache. During parse, the row cache is searched. The process searches through a linked list protected by the 'row cache objects' latch to find the object in the cache that it needs. When other processes are also parsing and looking through the row cache this may cause contention; especially if the parse activity is excessive or unnecessary.

'row cache objects' 等待事件有可能会带来高cpu占用,出现这个等待事件要及时处理。