oracle checkpoint 说明 -凯发app官方网站

the point of oracle checkpoints is to synchronize all datafiles, some datafiles orsome objects to a point in time for consistency, performance and recoverabilitypurposes.

1.3 buffer cache

checkpoint与buffer cache 的关系很大，有关buffer cache，之前整理的相关文章如下：

1.3.1 buffer cache 组成

the buffer cache component structures are:

（1）buffers

eachbuffer may hold an image of one data block at any one time

（2）buffer headers

=>storemetadata about contents of the buffers

=>actas cache management structures

（3）buffer pools

collectionof buffers used for the same purpose and managed accordingly

（4）working set

=>allor part of a buffer pool

=>assigned to a dbwn process

1.3.2 buffer management

（1） cached buffers managed by doublylinked lists:

（2） repl

=>bufferscontaining block images being used

（3） repl-aux

=>buffersready to be used for i/o or cr build

关于cr 参考：

（4） write and ckpt-q

=>dirtybuffers requiring i/o

（5） write-aux

=>dirtybuffers with i/o in progress

（6） touch count is used to decide theinitial insertion location in the repl chain

（7） aux lists avoid wasteful scanning

1.3.3 redo and the buffer cache

（1） block modification dirties thebuffer containing the block image and generates redo

（2） a buffer becomes dirty at aparticular rba which is a point in the redo stream

关于rba,参考我的blog：

（3） redo written by lgwr makes thecorresponding part of the redo log file “active”

（4） dirty block images written by dbwnmakes the corresponding part of the redo log file “inactive”

（5） redo is always written priorto the corresponding block images

（6） size of active redo in the logfile influences instance and crash recovery time

（7） trade-off between performance andrecovery time

1.3.4 buffer cache i/o

（1）servers look for an availablebuffer on repl-aux then read a data block into selected buffer

link url:

阅读(1380) | 评论(0) | 转发(0) |

上一篇： oracle 11g 默认审计选项说明

下一篇： oracle rba(redo byte address) 说明

给主人留下些什么吧！~~

| | | | |

感谢所有关心和支持过chinaunix的朋友们