control file sequential read等待事件
原创
©著作权归作者所有:来自51CTO博客作者maclean_007的原创作品,请联系作者获取转载授权,否则将追究法律责任
This is a read from a single copy of the control file. This happens in many cases. For example, while:
Making a backup of the controlfiles
Sharing information (between instances) from the controlfile
Reading other blocks from the controlfiles
Reading the header block
Solutions
Problem:
If wait time is significant, it usually means there's an I/O problem. Find out whether the waits are on particular copy of the controlfile and, if so, whether its I/O path is saturated. The following query can be used to find which controlfile is being accessed. It has to be run when the problem is occurring:
select P1 from V$SESSION_WAIT
where EVENT like 'control file%' and STATE='WAITING';
Possible solutions:
Move the problematic controlfile copy to a less utilized disk. Use Asynchronous I/O if available.
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
db file sequential read等待事件
最近某个应用的AWR中总显示“db file sequential read“等待事件位于top 5之首,下面检索下M
Oracle 磁盘 缓存 等待事件 数据块 -
何时会发生db file sequential read等待事件
db file sequential read发生在哪些种情况
db file sequential r