最近在某用户系统中,发现有一个Latch等待非常显著:object queue header operation
Bug 7588384 Long waits for ‘object queue header operation’ / ‘cache buffers chains’ latches
这在10.2.0.4中被标记为BUG,在10.2.0.4.3之后被修正。
这个BUG的描述为:
Long latch waits may be seen on ‘object queue header operation’ and
‘cache buffers chains’ latches showing a holder location
of kcb_flush_undo_segment or kcb_flush_undo_buffersIn some instances, nodes can crash with ORA-481 or ORA-484
影响版本还包括:11.1.0.7。
其主要的Latch竞争点位于: kcb_flush_undo_segment 或者 kcb_flush_undo_buffers 。
相关文章|Related Articles
- simulator lru latch – Oracle自动评估的代价
- 诊断案例:PMON failed acquire latch QMNC Holder
- Latch Row Cache Objects基本信息的确认
- 数据字典视图之:V$LATCH_CHILDREN 结构
- Oracle KSL Latch 管理层 与 Latch管理
评论数量(0)|Add Comments
本文网址:http://www.eygle.com/archives/2011/12/latch_object_queue_header_operation.html