<pre name="code" class="sql">buffer pool latch 是用来保护buffer pool的
每个buffer pool有一个buffer pool latch保护
SQL> select addr,LATCH#,LEVEL#,CHILD#,NAME from v$latch_children where name='buffer pool';
ADDR LATCH# LEVEL# CHILD# NAME
-------- ---------- ---------- ---------- ----------------------------------------------------------------
2CD760A8 146 1 8 buffer pool
2CD75F78 146 1 7 buffer pool
2CD75E48 146 1 6 buffer pool
2CD75D18 146 1 5 buffer pool
2CD75BE8 146 1 4 buffer pool
2CD75AB8 146 1 3 buffer pool
2CD75988 146 1 2 buffer pool
2CD75858 146 1 1 buffer pool
已选择8行。
cache buffers chains latch是用来保护 hash buckets:
SQL> SELECT x.ksppinm NAME, y.ksppstvl VAL
buffer pool latch和cache buffers chains latch
最新推荐文章于 2024-02-22 16:01:33 发布
本文介绍了Oracle数据库中用于保护Buffer Pool的Buffer Pool Latch,以及用于保护hash buckets的Cache Buffers Chains Latch。通过查询显示了Buffer Pool Latch的数量,并解释了一个Cache Buffers Chains Latch平均管理的块数为16个。
摘要由CSDN通过智能技术生成