博客
关于我
强烈建议你试试无所不能的chatGPT,快点击我
db file parallel write等待事件
阅读量:4350 次
发布时间:2019-06-07

本文共 961 字,大约阅读时间需要 3 分钟。

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.

转载于:https://www.cnblogs.com/macleanoracle/archive/2013/03/19/2967887.html

你可能感兴趣的文章
20190823 顺其自然
查看>>
阅读《余生有你,人间值得》有感
查看>>
每日英语
查看>>
20190914 防城港高级传销体验3日
查看>>
20190925 Phrase Of The Day
查看>>
20190925 软件实施
查看>>
python的命名空间
查看>>
*args 和 **kwargs 的区别
查看>>
洛谷P3372 【模板】线段树 1 分块
查看>>
【魔板】题解
查看>>
PDF数据防扩散系统介绍
查看>>
Android APP性能分析方法及工具
查看>>
MySQL删除表数据
查看>>
HTML5商城开发三 jquery 星星评分插件
查看>>
IDGeneratorUtil-主键生成工具类
查看>>
C#正则分组实例
查看>>
在CMD中操作mysql数据库出现中文乱码解决方案
查看>>
C 练习(四)
查看>>
VB读写进程的内存
查看>>
css float引发的塌陷问题及解决方案
查看>>