WAITEVENT:latch:cachebufferschains
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了WAITEVENT:latch:cachebufferschains,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含7231字,纯文字阅读大概需要11分钟。
内容图文
![WAITEVENT:latch:cachebufferschains](/upload/InfoBanner/zyjiaocheng/562/3e3b94f5191f4dc58d2d00597fbdd2a9.jpg)
关于CACHE BUFFERS CHAINS描述 CACHE BUFFERS CHAINS latch is acquired when searching for data blocks cached in the buffer cache. Since the Buffer cache is implemented as a sum of chains of blocks, each of those chains is protected by a child
关于CACHE BUFFERS CHAINS描述
CACHE BUFFERS CHAINS latch is acquired when searching
|
产生CACHE BUFFERS CHAINS原因
The main cause of the cache buffers chains latch contention is usually a hot block issue.
|
CACHE BUFFERS CHAINS 处理方法
1) Examine the application to see if the execution of certain DML and SELECT statements can be reorganized to eliminate contention on the object.
处理方法如下:
|
Note:1342917.1 Troubleshooting ‘latch: cache buffers chains’ Wait Contention
2) Decrease the buffer cache -although this may only help in a small amount of cases.
3) DBWR throughput may have a factor in this as well.If using multiple DBWR’s then increase the number of DBWR’s.
4) Increase the PCTFREE for the table storage parameters via ALTER TABLE or rebuild. This will result in less rows per block.
找出热点对象
|
5) Consider implementing reverse key indexes (if range scans aren’t commonly used against the segment)
![](http://www.gxlcms.com/Public/aiod/ts.jpg)
mysql热搜
- CiscoACL在VLAN或端口上阻止蠕虫端口
- Oracle中EBS更新银行地址
- 2013年计算机等级考试二级Access第一章精讲4
- 等级考试二级Access考点分析:数据库和表
- Mac下MySql的启动、停止
- 在Ubuntu中安装MySQL
- 项目经理修炼之道(2)--必须读的书
- 微软8年潜行高性能计算发布08Beta2
- 操作系统之进程管理(2)
- 数据库中的表以行和列来组织数据,每一行称为每一列称为
- mysql存储过程中使用动态sql语句
- 怎么修改mysql的默认端口号
- mysql索引更新要多久
- sql语言容易学吗?
- MySQL中十进制转八进制的实现方法
- sql中查询命令的关键字是哪些?
- sql增删改查语句怎么写
- sql求和语句怎么写?
- SQL命令有哪几种类型
- mysqlworkbench是什么
- DBMS的体系结构有哪些类型
- 如何理解数据库事务隔离级别及脏读、不可重复读、幻读
- 使用JAVA进行数据库部分知识的操作代码
- 系统整理SQL中GroupBy的用法与GroupBy多个字段限制
- mysqlcount查询速度很慢怎么办?mysql查询速度优化方案
![](http://www.gxlcms.com/ad/tx500x500.jpg)