yaari 发表于 2017-7-7 20:56:32

DBWn写规则

DBWn写规则作为oracle数据文件写入进程，DBWn写规则在百度上有多种版本，其实翻看oracle官方文档。只有2种情况DBWn进程才会写：database buffer cache空间不足和instance 恢复。The DBWn process writes dirty buffers to diskunder the following conditions:·      When aserver process cannot find a clean reusable buffer after scanning a thresholdnumber of buffers, it signals DBWn to write. DBWn writes dirty buffers to diskasynchronously if possible while performing other processing.·      DBWn periodicallywrites buffers to advance the checkpoint,which is the position in the redo thread from which instance recovery begins (see "Overview of Checkpoints"). The log position of the checkpoint is determined by theoldest dirty buffer in the buffercache.

f1662 发表于 2017-7-7 21:44:04

{:6_290:}

Rockyw 发表于 2017-7-7 22:30:11

感谢楼主分享！

xianyu166 发表于 2017-11-10 21:25:56

还有check point的时候
页: [1]
查看完整版本: DBWn写规则