db file parallel write和db file parallel read

最新推荐文章于 2024-03-24 21:46:48 发布

scan724

最新推荐文章于 2024-03-24 21:46:48 发布

阅读量1.1k

点赞数

分类专栏： OWI

本文链接：https://blog.csdn.net/zhaoyangjian724/article/details/38960523

版权

OWI 专栏收录该内容

87 篇文章 34 订阅 ¥39.90 ¥99.00

订阅专栏

本文讨论了Oracle数据库中与I/O相关的两个关键事件：db file parallel write和db file parallel read。db file parallel write是DBWR后台进程在进行并行文件写操作时的等待事件，可能表示I/O性能问题。而db file parallel read主要发生在恢复期间或预读取优化时，用于并行读取需要更改的数据库块。

摘要由CSDN通过智能技术生成

<pre name="code" class="sql">db file parallel write 
This event occurs in the DBWR. It indicates that the DBWR is performing a parallel write to files and blocks. The parameter requests indicates the real number of I/Os that are 

being performed. When the last I/O has gone to disk, the wait ends. 

Wait Time: Wait until all of the I/Os are completed 

Parameters: 

files
This indicates the number of files to which the session is writing

blocks
This indicates the total number of blocks to be written

requests
This indicates the total number of I/O requests, which will be the same as blocks

个等待是磁盘IO引起的问题，跟其他都没关系，这是后台进程DBWR的等待。从BUFFER CACHE写数据到硬盘里，写的速度太慢，所以等


待


在Oracle 10g中，db file parallel

了解本专栏