control file parallel write等待事件

简介:

This event occurs when a server process is updating all copies of the controlfile. Controlfile updates occur in the following situations: A checkpoint is reached The session starts a control file transaction (to make sure that the control files are up to date in case the session crashes before committing the control file transaction) The session commits a transaction to a control file Changing a generic entry in the control file, the new value is being written to all control files Solutions If this wait is significant, check for I/O problems. Possible points of trouble include controllers and physical disks. Check for all of the controlfile copies. Limit controlfile copies, but consider the increased risk of losing all controlfiles at once. If possible, use Asynchronous I/O. Move the controlfiles to drives with less I/O activity. Frequency of controlfile access is governed by activities such as Redo Logfile switching and Checkpointing. Therefore focus on tuning these activities if the I/O paths are healthy.



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

相关文章
|
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
|
关系型数据库 Oracle iOS开发