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

paulyibinyi發表於2013-04-18
      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佔用,出現這個等待事件要及時處理。

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-758805/,如需轉載,請註明出處,否則將追究法律責任。

相關文章