0316理解db file parallel read等待事件

简介: [20180316]理解db file parallel read等待事件.txt --//一直对db file parallel read等待事件不理解,因为在实际系统中很少遇到这样的等待事件.

[20180316]理解db file parallel read等待事件.txt

--//一直对db file parallel read等待事件不理解,因为在实际系统中很少遇到这样的等待事件.

SCOTT@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

SCOTT@test01p> @ ev_name 'db file parallel read'
EVENT#   EVENT_ID NAME                  PARAMETER1 PARAMETER2 PARAMETER3 WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS
------ ---------- --------------------- ---------- ---------- ---------- ------------- ----------- --------------------
   152  834992820 db file parallel read files      blocks     requests      1740759767           8 User I/O

--//参数1,2,3对应的files,blocks,requests.非常的不明确.

https://docs.oracle.com/cd/E11882_01/server.112/e40402/waitevents003.htm#REFRN00531

db file parallel read

This happens during recovery. It can also happen during buffer prefetching, as an optimization (rather than performing
multiple single-block reads). Database blocks that need to be changed as part of recovery are read in parallel from the
database.

Wait Time: Wait until all of the I/Os are completed
------------------------------------------------------------------------------------------------
Parameter     Description
------------------------------------------------------------------------------------------------
files         This indicates the number of files to which the session is reading
blocks        This indicates the total number of blocks to be read
requests      This indicates the total number of I/O requests, which will be the same as blocks
------------------------------------------------------------------------------------------------

--//这里实际上参数P1是files值读文件的数量.而不是文件号.
--//P2,读取的数据块数量.注意读取的块可以不连续.
--//P3.requests .理论应该等于P2的数值.

--//按照文档介绍发生在This happens during recovery. It can also happen during buffer prefetching, as an optimization
--//(rather than performing multiple single-block reads).

--//如何测试呢?一般awr报表很难出现这个等待事件.留待下个星期测试.12c的TABLE ACCESS BY INDEX ROWID BATCHED特性会出现这个等待事件.
--//回家测试看看.

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