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
分享到:
相关推荐
The db file sequential read Oracle metric event signifies that the user process is reading buffers into the SGA buffer cache and is waiting for a physical I/O call to return. This call differs from a...
db file sequential read(ms) log file parallel write(ms) log file sync(ms) db file scattered read(ms) #IO WorkLoad Oracle IOPS Oracle MBPS db file sequential read db file scattered read log file ...
并发程序的验证方法和基础.对于编写并行程序、并行程序测试、程序正确性验证等方面的同学值得一看
Algorithms Sequential and Parallel A Unified Approach, Russ Miller, Laurence Boxer, 3ed, Cengage, 2013
buffer busy waits db file parallel write db file single write db file scattered read db file sequential read diret path write/read enqueue
Algorithms Sequential and Parallel A Unified -- A Unified Approach, Second Edition, 2005
Sequential Logic and Verilog HDL Fundamentals discusses the analysis and synthesis of synchronous and asynchronous sequential machines. These machines are implemented using Verilog Hardware ...
Each database is stored as a single file containing both Pragma & Data Writes cause file locking and are always sequential and blocking Reads can be multi-tasked Designed for local use NOT Client-...
CMU 15210 Parallel and Sequential Data Structures and Algorithms 课本
verification of sequential and concurrent programs-third extended edition,一本很实用的英文书
Algorithms Sequential and Parallel - A Unified Approach, 2rd Edition 英文非影印版
时间序列分析——The main focus of this book is on a systematic development of the theory of sequential hypothesis testing (Part I) and changepoint detection (Part II). In Part III, we briefly describe...
自己总结的关于datastage sequential stage属性的说明。希望对各位同志有用,如果有不对的地方请多多指教。
串并行数据结构及算法
严蔚敏数据结构与算法▲课本算法实现
对SC(Sequential Consistency)和TSO(Total Store Order)内存模型进行了讲解, 浅显易懂, 用最简明的图示讲明了二者的区别, 适合初步学习相关知识的同学阅读.
Since sequential information plays an ...art sequential recommendation methods and context-aware recommendation methods on two public datasets, i.e., the Taobao dataset and the Movielens-1M dataset.
队列等待之TX - allocate ITL entry引起的死锁处理 ...Db file sequential read异常等待事件分析与处理。 Db file scattered read异常等待事件分析与处理。 Direct path read异常等待事件分析与处理。
limitations: They are not designed for sequential analysis of incomplete trajectories or online learning based on an incrementally updated training set. Moreover, they typically involve tuning of many...