oracle等待事件buffer exterminate

最新推荐文章于 2023-02-25 20:29:49 发布

洛阳城头见洛阳

最新推荐文章于 2023-02-25 20:29:49 发布

阅读量1.4k

点赞数

分类专栏： oracle基础知识

本文链接：https://blog.csdn.net/killvoon/article/details/46726983

版权

Oracle的Buffer Exterminate等待事件发生在尝试动态调整SGA组件大小，如缓冲区缓存时。当SGA组件动态缩小，且会话访问即将被释放的缓冲区格内的数据块时，会发生此等待。检查V$SGA_DYNAMIC_COMPONENTS、V$SGA_CURRENT_RESIZE_OPS和V$SGA_DYNAMIC_FREE_MEMORY视图可以帮助诊断SGA调整操作。大量出现此等待可能需要考虑禁用SGA自动管理或设定内存组件最小值。

摘要由CSDN通过智能技术生成

在刷oracle当前等待事件情况的时候，偶尔看到这个叫 buffer exterminate的等待事件，之前没有见到过，便查找下相关资料整理一下。在刷oracle当前等待事件情况的时候，偶尔看到这个叫

This wait event usually occurs when you have tried to dynamically resize a component of the SGA such as the buffer cache.

The "buffer exterminate" waits can only happen if part of the buffer cache is being dynamically shrunk and a session wants access to a data block that resides in a db cache buffer within a granule chosen to be freed. After the buffer is freed (removed from buffer cache hash chain, LRU chain, etc.), one of the waiting sessions can then reload that block into one of the remaining db cache granules, and everyone else eventually finds the new buffer address for the data block via hash lookup.

You can check the following views to see if any recent SGA Component resize operations have taken place :