Buffer Cache与IO相关的等待事件:
这种等待事件的产生原因是包含DBWR进程和IO Slaves的Buffer Cache操作。
'db file parallel write' , 'db file single write', 'write complete waits', 'free buffer waits'
如下文档会有相关更详细的介绍:
Document 34416.1 WAITEVENT: "db file parallel write" Reference Note
Document 62172.1 Understanding and Tuning Buffer Cache and DBWR
Document 76713.1 8i Parameters that Influence Checkpoints
Document 147468.1 Checkpoint Tuning and Troubleshooting Guide
结论:
作为这篇文章的总结,无论何时IO性能和响应时间出现问题了,检查操作系统日志中的相关错误都是有帮助的。如果IO子系统出故障了,那么就很难从Oracle数据库层面探究IO性能问题。如果这个问题是硬件导致的,那么应该寻求操作系统或文件系统供应商的帮助。
(Finished)
分享到:
相关推荐
vsphere-esxi-vcenter-server-55-troubleshooting-guide
vsphere-esxi-vcenter-server-511-troubleshooting-guide
vsphere-esxi-vcenter-server-501-troubleshooting-guide
python库。 资源全名:troubleshooting-framework-1.3.0.3.tar.gz
JDK11-troubleshooting-guide
JDK13-troubleshooting-guide
JDK18-troubleshooting-guide
JDK19-troubleshooting-guide
JDK12-troubleshooting-guide
JDK15-troubleshooting-guide
JDK16-troubleshooting-guide
JDK17-troubleshooting-guide
troubleshooting-linux-kernel-modules-and-device-drivers1.ppt
GTFM_troubleshooting-deep-neural-networks-OpenAI专家指导你改模型-141页.pdf
Java Platform, Standard Edition Troubleshooting Guide-231
NetBackup__52xx_5030_Troubleshooting_Guide_2604
vsan6.7故障及性能配置文档
openstack 生存排错指南.
2.2.2.4 Packet Tracer - Troubleshooting Inter-VLAN Routing.pka
JDK9-JSE-Troubleshooting Guide-244