db file parallel write等待事件
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
This event occurs in the DBWR. It indicates that the DBWR is performing a parallel write to files and blocks. When the last I/O has gone to disk, the wait ends. This wait only occurs in the DBWR processes.
Problem
Ultimately, the operating system's I/O subsystem is the bottleneck. User sessions wait for DBWR to complete the process of flushing dirty blocks from the buffer cache. To further determine user sessions that are also impacted, look for long wait times on "write complete waits" and / or "free buffer waits".
Solution
Two possible solutions for extensive waits on db file parallel write are to Improve DBWR Throughput or to reduce I/O rate demands.
This wait may also stem unnecessarily frequent flushing of the buffer cache by the DBWR. Have a look at the view V$INSTANCE_RECOVERY to see if the target recovery time is leading to excessive writing of blocks from the cache.
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
Oracle db file parallel write 和 log file parallel write 等待事件 说明
一. db file parallel write 等待事件引自如下blog:
parallel file oracle database buffer -
log file sync(日志文件同步) 与 Log file parallel write 等待事件
log file sync(日志文件同步)等待事件具有一个参数:buffer#。在Oracle Database 10g中
file parallel 文件同步 数据库 buffer