control file sequential read等待事件

简介:

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.



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

相关文章
|
Oracle 前端开发 关系型数据库
log file sync 和 log file parallel write等待事件的区别和联系
log file parallel write 和log file sync这两个等待事件关系密切,很多人对这两个等待事件有一些误解,我们先来看看Oracle官方文档的解释:
131 0
|
SQL Oracle 关系型数据库
ORACLE等待事件: log file parallel write
log file parallel write概念介绍 log file parallel write 事件是LGWR进程专属的等待事件,发生在LGWR将日志缓冲区(log_buffer)中的重做日志信息写入联机重做日志文件组的成员文件,LGWR在该事件上等待该写入过程的完成。
1618 0
0322理解db file parallel read等待事件2
[20180322]理解db file parallel read等待事件2.txt --//上个星期的学习:http://blog.itpub.net/267265/viewspace-2151973/ https://docs.
1145 0
|
关系型数据库 Oracle iOS开发
|
关系型数据库 Oracle iOS开发