db file parallel read
来源:互联网 发布:行走机器人的算法 编辑:程序博客网 时间:2024/06/02 06:20
等待事件 :
This happens during recovery.
发生在恢复过程中。
It can also happen during buffer prefetching, as an optimization (rather than performing multiple single-block reads).
也发生在buffer 预读取,作为多次单块读的优化方法。
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
This Wait Event is used when Oracle performs in parallel reads from multiple datafiles to non-contiguous buffers in memory (PGA or Buffer Cache).
当oracle从多个数据文件中读取到内存的buffer中去(PGA或buffer cache)。、
If this wait is an important component of Wait Time, follow the same guidelines as 'db file sequential read'.
如果此事件作为等待事件重要的组成部分,参考'db file sequential read'
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
- db file parallel read
- 优化db file parallel read
- db file parallel write和db file parallel read
- Oracle IO问题解析(八)—— db file parallel read
- I/O上的等待事件 —— db file parallel read
- db file sequential read
- db file sequential read
- db file sequential read
- db file scattered read
- db file scattered read
- db file scattered read
- db file scattered read
- db file parallel write,write complete waits
- db file parallel write, write complete waits
- db file parallel write,write complete waits
- db file parallel write,write complete waits
- db file sequential read与db file scattered read
- db file sequential read事件
- C#(合并GridView列中相同的行)
- 其实我有些迷茫
- spring学习笔记10--Spring+jdbc组合开发(注解方式配置事务)
- Java与Http协议(HttpURLConnection和HttpClient)
- 文字竖排
- db file parallel read
- 程序员_Java高新技术<二>
- DataTable重命名列、删除列、排序列
- c# Repeater中CommandArgument传多个参数
- 序号互换
- [译] Dojo 工具包参考手册
- 虚拟内存
- 特别费时间:客户需求,数据准备,报表制作
- HDU 2845 Beans (DP)