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

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

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占用,出现这个等待事件要及时处理。

本文标签:
网站声明:本文由风哥整理发布,转载请保留此段声明,本站所有内容将不对其使用后果做任何承诺,请读者谨慎使用!
【上一篇】
【下一篇】