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

相关文章
|
关系型数据库
### avoid read-on-write
### avoid read-on-write 什么是 "read-on-write" problem? 在我们使用最常见的buffer write 中 "read-on-write" 问题指的是当我需要进行小于4k 大小buffer write 的时候, 需要先将数据所在的page 从disk 中读取出放入到page cache, 在page cache 中修改好, 然后再将
1488 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开发
|
Oracle 关系型数据库 数据库
20171110_allow_read_only_corruption参数
[20171110]_allow_read_only_corruption参数.txt --//昨天在修改查询隐含参数脚本时发现一个参数_allow_read_only_corruption,感觉应该可以在异常关闭的情况下以read only打开.
1215 0