Oracle waits event:DB File Sequential Read
来源:互联网 发布:女生学软件测试怎么样 编辑:程序博客网 时间:2024/06/05 18:21
The DB File Sequential Read wait event generally indicates a single block read (an index read,
for example). A large number could indicate poor joining orders of tables or unselective indexing.
This number will certainly be large (normally) for a high-transaction, well-tuned system. You
should correlate this wait with other known issues within the STATSPACK report such as
inefficient SQL. Check to ensure index scans are necessary and check join orders for multiple
table joins. The DB_CACHE_SIZE will also be a determining factor in how often these waits show
up; hash-area joins causing problems should show up in the PGA memory but similarly are
memory hogs that can cause high wait numbers for sequential reads or can also show up as
direct path read/write waits. Range scans can read a lot of blocks if the data is spread in many
different blocks (density within blocks could cause issues with range scans, and reverse key
indexes could be problematic with range scans). Loading data in a sorted manner can help
range scans and reduce the number of blocks read. Partitioning can help, as it can eliminate
some blocks. Look for unselective indexes that are causing a lot of these. Locate the data on
disk systems that either have more disk caching and/or are buffered by OS file system cache.
Correlated to the waits are the values for P1,P2,P3=file, block, blocks.
- Oracle waits event:DB File Sequential Read
- Oracle Waits event:DB File Scattered Read
- Oracle wait event --- db file sequential read
- db file sequential read
- db file sequential read
- db file sequential read
- High Waits on 'Db File Sequential Read' Due to Table Lookup Following Index Access
- db file sequential read事件
- 模拟DB File Sequential Read
- db file sequential read 详解
- oracle之 db file sequential read等待事件优化思想
- High Waits on 'Db File Sequential Read' Due to Table Lookup Following Index Access (文档 ID 875472.1)
- db file sequential read与db file scattered read
- 数据库中db file sequential read事件
- db file sequential read等待事件
- db file sequential read等待事件
- db file sequential read等待事件
- db file sequential read等待事件
- c#委托事件
- 词法分析(字符串分析)
- Linux C 使用指针访问成员
- Oracle Waits event:DB File Scattered Read
- 开始学习Linux
- Oracle waits event:DB File Sequential Read
- css中的border属性
- 实时操作系统中断延时尽可能小
- debug下的build错误
- 五十行代码能否笼络女人的心?
- android消息机制,异步和多线程
- Spring的ApplicationContext加载Property文件
- 关于基本三角函数反函数的图像问题+正切,余切
- include 和 include "" 的区别