db file parallel read等待事件

简介:

The process has issued multiple I/O requests in parallel to read blocks from data files into memory and is waiting for all requests to complete. This occurs during regular activity when a session batches many single block I/O requests together and issues them in parallel. This is also occurs during recovery. This wait event does not apply to parallel query or parallel DML. Solutions Block reads are necessary in a database, but it is important to limit unnecessary I/O. The best way to do this is by making the application as efficient as possible in regard to its data access requirements. Also, creating efficient SQL can produce large gains in performance. In contrast, changes to the RDBMS itself may produce smaller performance improvements. Identify and resolve any SQL using unselective index scans. Use Ignite to find SQL with a large "db file parallel read" wait time -- indicating a long index scan. Look at the explain plan to see if the index scan is high cost with low cardinality. Try increasing the size of the buffer cache with DB_BLOCK_BUFFERS if enough memory is available on the server. This should reduce the cost of the I/O, since the necessary data is more likely to be in memory, but it won't reduce the amount of I/O. Consider using the operating system's data cache if available. For tables that are frequently accessed via index scans, placing their corresponding data files on buffered file systems can reduce the I/O to actual drives. Evaluate Data Clustering. Evaluate whether table partitioning can reduce the amount of data needed to navigate to satisfy your queries.


本文转自maclean_007 51CTO博客,原文链接:http://blog.51cto.com/maclean/1277906

相关文章
|
Oracle 前端开发 关系型数据库
log file sync 和 log file parallel write等待事件的区别和联系
log file parallel write 和log file sync这两个等待事件关系密切,很多人对这两个等待事件有一些误解,我们先来看看Oracle官方文档的解释:
167 0
|
SQL Oracle 关系型数据库
ORACLE等待事件: log file parallel write
log file parallel write概念介绍 log file parallel write 事件是LGWR进程专属的等待事件,发生在LGWR将日志缓冲区(log_buffer)中的重做日志信息写入联机重做日志文件组的成员文件,LGWR在该事件上等待该写入过程的完成。
1623 0
0322理解db file parallel read等待事件2
[20180322]理解db file parallel read等待事件2.txt --//上个星期的学习:http://blog.itpub.net/267265/viewspace-2151973/ https://docs.
1149 0
|
关系型数据库 Oracle Linux
0316理解db file parallel read等待事件
[20180316]理解db file parallel read等待事件.txt --//一直对db file parallel read等待事件不理解,因为在实际系统中很少遇到这样的等待事件.
1208 0