Difference between DB File Sequential and Scattered Reads
来源:互联网 发布:2016年汽车保险数据 编辑:程序博客网 时间:2024/05/16 05:19
Both "db file sequential read" and "db file scattered read" events signify time waited for I/O read requests to complete. Time is reported in 100's of a second for Oracle 8i releases and below, and 1000's of a second for Oracle 9i and above. Most people confuse these events with each other as they think of how data is read from disk. Instead they should think of how data is read into the SGA buffer cache or user PGA memory.
db file sequential read:
A sequential read operation reads data into contiguous memory (usually a single-block read with p3=1, but can be multiple blocks). Single block I/Os are usually the result of using indexes. This event is also used for rebuilding the controlfile and reading datafile headers (P2=1). In general, this event is indicative of disk contention on index reads.
db file scattered read:
Similar to db file sequential reads, except that the session is reading multiple data blocks and scatters them into different discontinuous buffers in the SGA. This statistic is NORMALLY indicating disk contention on full table scans. Rarely, data from full table scans could be fitted into a contiguous buffer area, these waits would then show up as sequential reads instead of scattered reads. However, scattered read will never read just one block (p3 is always >= 2).
The following query shows average wait time for sequential versus
scattered reads:
转自:http://www.orafaq.com/node/1
- Difference between DB File Sequential and Scattered Reads
- db file sequential reads
- db file sequential read与db file scattered read
- about FTS(Full Table Scan) V db file scattered read&db file sequential read
- db file scattered read
- db file scattered read
- db file scattered read
- db file scattered read
- Difference between Global DB name and SID
- 模拟db file scattered read
- 【REPOST】db file scattered read
- db file sequential read
- db file sequential read
- db file sequential read
- What is the difference between 0 dB and 0 dBFS
- Oracle Waits event:DB File Scattered Read
- Common Wait Events---db file scattered read
- db file scattered read等待事件
- 在Web浏览器中显示Excel文档时碰到的错误
- windows下正确配置CUDA 4.0环境并在Visual Studio 2008中新建工程
- 黑马程序员训练营:字符编码
- 大病之前的先兆(不得不看)
- 肾有多好人就有多年轻——男女通用
- Difference between DB File Sequential and Scattered Reads
- 提高记忆力的方法
- 泡脚最补肾,时间有讲究。手脚凉的人必看
- OO初探
- 转 fedora 下安装 firefox4.0
- 软件架构师的成长之路
- 喝白开水治病——应该这样喝
- 再严重的感冒,马上就好!!
- winsock原理