control file parallel write等待事件
原创maclean_007 ©著作权
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
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.
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
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