博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
db file scattered read等待事件
阅读量:6951 次
发布时间:2019-06-27

本文共 1198 字,大约阅读时间需要 3 分钟。

Waits on this event indicate the statement is performing a full table scan or an index range scan. This is often reduced by adding an index or making the index more efficient. Solutions Tune the SQL statement so that it uses an index rather than a full table scan if warranted. If the table is small, a full table scan could be more efficient that using an index so test the differences. Use the Ignite Objects tab to determine the most costly full table scan if there are more than one table in the query. Increase the buffer cache so that more blocks are already in memory rather having to be read from disk. The query will still need to read the same number of blocks so tuning is the first recommendation, but if you cannot tune the statement, a query reading blocks from memory is much faster than from disk. Slow disks could be causing Oracle to spend time reading the data into the buffer cache. Review the 'DB Multi Block Disk Read Time' metric in Ignite to determine disk speeds from Oracle's perspective. If the time to read data is above 30ms, that could indicate slow disks. Update table and index statistics if they are stale so that Oracle understands the benfits of existing indexes.

转载地址:http://vdkil.baihongyu.com/

你可能感兴趣的文章
C#排序算法
查看>>
[NOI2009]变换序列
查看>>
Dubbo项目一段时间后提供者消失
查看>>
oracleXE版本相关问题整理
查看>>
前台取json对象中的数据
查看>>
防火墙技术 配置基于区域策略的防火墙
查看>>
HTTP协议的理解
查看>>
bzoj 2301: [HAOI2011] Problem b
查看>>
牛客21天刷题_day#1
查看>>
xmlhelper类
查看>>
anisotropy texture filtering
查看>>
java list 遍历方式比较
查看>>
百度美图
查看>>
JPEGOPTIM压缩优化
查看>>
js ES6 多行字符串 连接字符串
查看>>
转:最佳实践:更好的设计你的 REST API
查看>>
Facebook被指“山寨”,背后真相是“炒作”还是……
查看>>
不要相信短信:iOS漏洞允许用户发送虚假短信
查看>>
南阳845(无主之地)
查看>>
笔迹之始
查看>>