Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Checkpoint and task of DBW0/LGWR

500237Dec 12 2007 — edited Dec 29 2007
Hi All,

I am a bit confused about the working of DBW0 and LGWR processes.

"A checkpoint performs the following three operations:
Every dirty block in the buffer cache is written to the data files. That is, it synchronizes the datablocks in the buffer cache with the datafiles on disk.
It's the DBWR that writes all modified databaseblocks back to the datafiles. "

I know this is very basic question and have read many documents about this.
But my question is,if DBW0 itself writes the blocks to disk(datafiles) then what is the task of LGWR ( writing from redo log buffer to online redo log and then to datafiles).Online redo logs will store all modified (committed) redo records and will flush the contents to datafile at some interval.Then isnt the same task performed by DBWR???

Thanks,
Aashish S.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 26 2008
Added on Dec 12 2007
40 comments
9,604 views